Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup not working because of duplicate matches
I have tried a little bit of everything (VLOOKUP, LOOKUP, INDEX, SMALL) but
to no avail. Here is my problem: Worksheet 1: A B C D E 1 xxxx xxxx 1234 100 xxxx 2 xxxx xxxx 1234 200 xxxx 3 xxxx xxxx 1234 300 xxxx 4 xxxx xxxx 4567 100 xxxx Worksheet 2: A B C 1 1234 200 In cell C1 above, I need a formula that looks in Worksheet 1 for the value in A1 (more than one record) and the value in A2 (the result should be row 2) and produce the value in the 5th column of that row (cell E2) I hope this makes sense and I hope someone out there can help me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and wildcards | Excel Worksheet Functions | |||
Vlookup 2 data matches? | Excel Discussion (Misc queries) | |||
vlookup issue ( not working and im tearing my hair out) | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
#N/A error with VLOOKUP | Excel Discussion (Misc queries) |