•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
vlookup + curly brackets
Perhaps too late to discover and blame it on unstructured self-learning:
Just learned that vlookup + curly brackets can be used to look up multiple columns. Spent a good part of my career writing several vlookups that could've been done much faster.
Edit: Adding sample from Gemini.
Formula Structure: =VLOOKUP("Key", A2:D10, {2, 3, 4}, FALSE)
{2, 3, 4}: Tells the formula to return the 2nd, 3rd, and 4th columns simultaneously.
Result: The data will automatically fill into three adjacent cells.
[link] [comments]
Want to read more?
Check out the full article on the original site