All articles with 'rank()' Tag

Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week]

Published on Nov 1, 2010 in Learn Excel
Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week]

Situation

Sometimes we don’t know what we want. If this happens when I am in a bar, I usually order a cocktail. Just a mix of everything. The same will work in Excel too.

For eg. If you have lots of data, but the value you want to look up needs to change based on whims and fancies of your users, then you can resort to a cocktail. A mix of VLOOKUP with Drop down lists (Data validation)

Read more to find how to solve this.

Continue »