Excel Tip: Multiple VLOOKUP

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

[an error occurred while processing this directive]

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:

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

Do you LIKE this page? Please let us know, and we will publish more of the content that YOU want. Salamat po!

Panuorin Mo Ito...

Visit SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka

Get In Touch With Manuel Today

  Previous Entry
  Next Entry

Secondthoughts @ Viloria.com
Manuel Viloria

About Manuel Viloria
Contact Us
Privacy Statement
RSS Feed

Google Reader

Copyright © 1996 - 2012 by Viloria.com All Rights Reserved.