Click here Subject Line Make your Pivot look better without blanks On a lighter note, you may not be able to grow hair on your head but you can surely grow hair on your Pivot (Zeros) to cover the blanks (baldness) Overview Sometimes you will have to prepare summary of the raw data which can
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
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.
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
Click here Subject Line Use Exact () for case sensitive values Overview As you already know a usual VLOOKUP () formula is case sensitive and will ignore case. Sometimes you may want to lookup exact value in a table. Hence we use Exact () function along with INDEX & MATCH function with an array formula