Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get multiple matches when using the Vlookup function?
If I have two spreadsheets and I need to match the data from one to the other
but I could have multiple matches, how can I use the vlookup to get the multiple matches and not just the first one? Or do I have to use another function? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get multiple matches when using the Vlookup function?
Hi!
Can you post an example of what the lookup table looks like (with "multiple matches")? In general, need a more detailed explanation. Biff "Lisa F" <Lisa wrote in message ... If I have two spreadsheets and I need to match the data from one to the other but I could have multiple matches, how can I use the vlookup to get the multiple matches and not just the first one? Or do I have to use another function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use the vlookup function to return a sum of the values? | Excel Discussion (Misc queries) | |||
VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
VLOOKUP Function using multiple worksheets | Excel Discussion (Misc queries) |