PDA

View Full Version : Vlookup and duplicates



sjoyce115
08-31-2006, 04:41 PM
Hello:

I have done a Yahoo search on this issue, and I can?t find the solution that I looking for. I am seeking your suggestions.

I use Vlookup that searches numbers in column A, and returns a value from Column D. Column A has several duplicates. My Vlookup formulas work very well except in case of the duplicates, Excel returns the same value from Column D. Is it possible that for each duplicate in Column A, Vlookup can return the corresponding value from D.?

Example:

Col A Col D
1245 25.00
1245 65.00
1254 75.00
1245 95.00

For each occurrence of 1245, Excel needs to return the value 25.00, then 65.00, then 95.00 and so on.


I have read Petermoran?s solution called VLOOKUPnth and HLOOKUPnth but it is not practical for me to nominate in each VLOOKUPNTH which entry I wish to find. Can someone offer a solution?

Regards,

Sean

CCkfm2000
08-31-2006, 04:56 PM
why don't you use advance filter?

sjoyce115
08-31-2006, 05:14 PM
Hello

Thanks for your reply. I am matching number from two different worksheets so advance filtering may not work. I simplified my first post so I could be easily understood.


Sean

CCkfm2000
08-31-2006, 05:43 PM
look at the attached file.

Shazam
08-31-2006, 06:10 PM
See if this helps.

Please look at the attachment below.

sjoyce115
09-01-2006, 01:46 PM
Thanks for your responses. I have the two options on a text run. I will get back to you with feedback.