Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup? for more than one criteria
I have a ss that contains the following:
(sheet1) #1. my source starts on sheet1 in cell b2 (this displays the company name). #2. (sheet2) #2a. names of companies from col h1:z1 product code list: b1:b50 #3. prices listed under the column for each company h1:h50, i1:i50, etc. What I want the formula to do is look at #1, for the company name, match to #2 on sheet2 ... Look at the product code on sheet1 and match to sheet2 product code then find the correct price for the item & company listed. Is this possible in a formula? Thanks for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup: 2 criteria | Excel Discussion (Misc queries) | |||
Conditional Lookup on Multiple Criteria | Excel Worksheet Functions | |||
Lookup based on two criteria in 1 row | Excel Discussion (Misc queries) | |||
2-Level (criteria) Lookup Function Help | Excel Worksheet Functions | |||
lookup with 2 criteria | Excel Discussion (Misc queries) |