0Hi,
Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot lookup value column is not left most even though Vlookup is able to get the Product Name or Branch details
Note1: Choose function 1st argument contains flower brackets
Note2: If you change the column index number to 3 then it will populate branch details.
Hope it's a helpful tip. Will catch you in my next tip
