| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two colums match return text from another
I have tried all these index / v look up solutions posted.
First sheet contains data base..... A B D 1 1 A Happys bar and grill 2 1 B SOnny's bar and grill 3 2 A Macks sweat shop On the second sheet, i want to enter a formula where i can look up (second sheet Q5 value in first sheet column A) then (Second sheet Q6 Value in first sheet column B) and if both criteria match return value into second sheet from first sheet column D |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting 2 colums to get numbers to match ? | Excel Worksheet Functions | |||
| MATCH 3 COLUMS RETURN 4TH | Excel Discussion (Misc queries) | |||
| MATCH 3 COLUMS RETURN 4TH | Excel Discussion (Misc queries) | |||
| match to colums vlookup | Excel Discussion (Misc queries) | |||
| Match text to another worksheet and return a certain value | Excel Worksheet Functions | |||
Threaded Mode
