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?