Excel Tip: Multiple VLOOKUP

If you're wondering how to make Excel apply VLOOKUP to more than one item, here's how.

Let's assume you have a database of suppliers, products they supplied, and the quantity supplied.

If you use the usual VLOOKUP() function of MS Excel, you can probably look up a supplier, and then display either the product supplied or the quantity supplied.

But what if you want to create a report that has Suppliers running down one column, and Products running left to right across one row, and you would like to display within that table the corresponding quantity supplied?

To make multiple VLOOKUPs, you'll need the "combine text" command.

Here's the sample Excel spreadsheet file so that you can see the way the formula was built:
multi-vlookup.xls

[ First posted on 08/22/2005 by Manuel Viloria ]