View Single Post
  #51   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Minnie Minnie is offline
external usenet poster
 
Posts: 11
Default How can I lookup when match has more than one value?


I had a question re duplicates as well:
I am trying to do a vlookup matching number figurers to their corresponding
year. However the years are duplicated:

Jan 1990 5555

feb 1990 4555

Mar 1990 4444

Jan 1991 54487

Feb 1991 2255

And so on...

i have a separate table with just the numbers. I am trying to match the
year to the numbers in the other table but am uable to use the vlookp due to
the duplicates.

Suggestions would be great!

Thanks!