Hi All,
VLOOKUP is one of the Excel's most useful as well as commonly used functions.
Here are some examples.
Data table:
Sheet1
* A B C D 1 Order ID Product Unit Price Quantity 2 10248 Queso Cabrales 14.00 12 3 10248 Singaporean Hokkien Fried Mee 9.80 10 4 10248 Mozzarella di Giovanni 34.80 5 5 10249 Tofu 18.60 9 6 10249 Manjimup Dried Apples 42.40 40 7 10250 Jack's New England Clam Chowder 7.70 10 8 10250 Manjimup Dried Apples 42.40 35 9 10250 Louisiana Fiery Hot Pepper Sauce 16.80 15 10 10251 Gustaf's Knäckebröd 16.80 6 11 10251 Ravioli Angelo 15.60 15 12 10251 Louisiana Fiery Hot Pepper Sauce 16.80 20
Excel tables to the web >> Excel Jeanie HTML 4
a simple VLOOKUP
Sheet1
* A B C D 18 Order ID Product Unit Price Quantity 19 10248 Queso Cabrales 14 12
Spreadsheet Formulas
Cell Formula B19 =VLOOKUP($A19,$A$2:$D$12,2,0) C19 =VLOOKUP($A19,$A$2:$D$12,3,0) D19 =VLOOKUP($A19,$A$2:$D$12,4,0)
Excel tables to the web >> Excel Jeanie HTML 4
continued on next post..
Reply With Quote
Bookmarks