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!
|