#22

Posted to microsoft.public.excel.worksheet.functions

Minnie

external usenet poster

Posts: 11

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Match and Lookup	Biocellguy	Excel Worksheet Functions	1	July 6th 07 01:48 AM
using MATCH, and LOOKUP	harvey1649	Excel Worksheet Functions	9	May 7th 07 07:05 AM
match, lookup ???	skimpw	Excel Worksheet Functions	0	August 14th 06 03:16 PM
Lookup? Match? pulling rows from one spreadsheet to match a text f	cjax	Excel Worksheet Functions	3	July 21st 06 02:51 PM
Lookup or Match	Robbyn	Excel Worksheet Functions	2	February 8th 05 10:29 PM

All times are GMT +1. The time now is 04:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us