software

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?

Hi!

Can you post an example of what the lookup table looks like (with quot;multiple
matchesquot;)?

In general, need a more detailed explanation.

Biff

quot;Lisa Fquot; lt;Lisa gt; wrote in message
...
gt; If I have two spreadsheets and I need to match the data from one to the
gt; other
gt; but I could have multiple matches, how can I use the vlookup to get the
gt; multiple matches and not just the first one? Or do I have to use another
gt; function?