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 ]



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


"Yes, I Want To Grow My Financial Life & Get The 11 TrulyRichClub Blessings!"

To Grab This Offer, Click Option Below:

Truly Rich Club Philippine Residents Click Here

Truly Rich Club International Residents Click Here



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

Get In Touch With Manuel Today
Manuel@Viloria.net



  Previous Entry
  Next Entry




Secondthoughts @ Viloria.com
"Invest in yourself, before
others will invest in you."
-- Manuel Viloria


Viloria.com
About Manuel Viloria
Secondthoughts
Archives
Angelhouser
Contact Us
Privacy Statement
RSS Feed


Google Reader


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