Excel Two Way Lookup Formula Tutorial
© Ted French
Although VLOOKUP is one of Excel's most used functions, on its own it is limited to using a single lookup criterion when trying to find information in a database.
By combining it with the MATCH function, however, we can create what is known as a two-way or two-dimensional lookup formula that allows us to easily cross reference two fields of information in a data table.
A two way lookup formula is useful when you want to find or compare results for a variety of different situations such as the price of different items over several months.
To find out all the details, read the step by step tutorial on the Excel Two Way Lookup Formula.
Related Tutorials
Comments
No comments yet. Leave a Comment