Find the 2nd,3rd,4th or Nth Value in excel

Click here Subject Line Lookup is dynamic and knows where to search Overview Sometimes you may need to look up the 2nd,3rd,4th or Nth value from a table i.e. based on the occurrences of the values dynamically lookup for the values. VLOOKUP () Function lookups a value from left side of the column and returns

Continue Reading

Three way Lookup

Click here Subject Line The THREE WAY Lookup makes multiple search criteria so simple Overview Sometimes you may want to do a three way lookup i.e. search on a combination of values in a table. You can build your own formula that to perform a Three -way lookup with help of INDEX and MATCH function.

Continue Reading

Using Drop Down lists as Lookup Values

Click here Subject Line The VLOOKUP () function can be made INTERACTIVE Overview Sometimes you may want to look up a value in a table using both rows and columns. You can build your own formula that to perform a two-way lookup with help of INDEX and MATCH function. In this example we are using

Continue Reading