Discover how to use VLOOKUP function with curly brackets in Excel. It is essentially vlookup formula with curly brackets. I will also answer what does curly brackets mean in Excel formula? br br VLOOKUP is one of the most widely used functions in Excel. It enables users to search for a specific value in a table and retrieve data from a corresponding column. However, in some cases, users may need to look up data from multiple columns simultaneously, and this is where the VLOOKUP function with curly brackets comes in handy. With this technique, users can perform a VLOOKUP operation across multiple columns at once, which can save time and improve data accuracy. In this article, we will explore how to use the VLOOKUP function with curly brackets in Excel and provide some practical examples to illustrate its usefulness. br br Create Drop Down List br 1) Select cell A2 br 2) Data ~ Data Validation br 3) Settings tab br 4) Allow set to List br 5) Source set to =$A$5:$A$43 br 6) Apply br 7) Select cell B2 br br For Model br =VLOOKUP($A$2,$A$5:$E$43,2,0) br br For Total Cost br =VLOOKUP($A$2,$A$5:$E$43,3,0) br br For Qty br =VLOOKUP($A$2,$A$5:$E$43,4,0) br br For Country br =VLOOKUP($A$2,$A$5:$E$43,5,0) br br Data In Horizontal Format br =VLOOKUP($A$2,$A$5:$E$43,{2,3,4,5},0) br br Data In Vertical Format br =VLOOKUP($A$2,$A$5:$E$43,{2;3;4;5},0) br br br What does curly brackets mean in Excel formula? br Curly brackets are how Excel recognises the numbers as an array formula.