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:
"Yes, I Want To Grow My Financial Life & Get The 11 TrulyRichClub Blessings!"
To Grab This Offer, Click Option Below:
Visit SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka
Get In Touch With Manuel Today
"Invest in yourself, before
others will invest in you."
-- Manuel Viloria
About Manuel Viloria