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? |
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? |
All times are GMT +1. The time now is 09:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com