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:
Panuorin Mo Ito...
Visit SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka
Get In Touch With Manuel Today
About Manuel Viloria