Tag: choose
-
A smarter multi criteria VLOOKUP in Excel
Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.
-
VLOOKUP: Right to Left Lookup
We all now know that VLOOKUP has one major constraint that the column in the lookup table from where the lookup value is to be searched should be the first column in the lookup table. Here is a tricky way that you can use to overcome this constraint. The trick…