VLOOKUP handling duplicates

[paladin12]

Please help me solve this problem. I have a list of part numbers that have price information associated with them from one department on one worksheet and on the other worksheet there are different prices associated to the same part numbers. I am using vlookup currently to be able to return the prices from the other department’s worksheet. The problem that I’m currently running into is that the part numbers are recurring on both sheets with different price data associated with each occurrence. My current formula only returns the first value of each instance of the part number. That formula is the following:

=IF(ISERROR(VLOOKUP(I416,Extract8.22!$K:$AK,25, FALSE)), "", VLOOKUP(I416,Extract8.22!$K:$AK,25, FALSE)).

Currently I have it set up to return a blank if there is an error returned from the vlookup. Please advise on how to return the cost associated with each instance of each part number regardless of duplicates.

Thanks!

[Søren Larsen]

How would you like the 2 prices returned? In 2 different cells, the same cell or something else?

BTW: You state that you are using Excel 2007, in which case your above formula can be reduced to:

Please Login or Register  to view this content.

[paladin12]

Thanks for the information on the shorter version of the formula.

Prices in two different columns is what I'm shooting for.

[Søren Larsen]

After reading your post again, I'm not sure I understand your setup. Do you have one sheet on which you want to return results from 2 different sheets, or do you have one a sheet from which you want to return multiple loookup results?