Returning multiple values for a lookup

C

cfincham

I have a spreadsheet showing the purchases of various part numbers wit
the corresponding unit costs paid, there is normally more than one uni
cost per part number. On a second spreadsheet, I want to be able loo
up a given part number in Column A and pull over the corresponding uni
costs paid into Column B. I have no problem pulling over the firs
unit cost found, but am not able to get the second, third, etc, uni
cost found. Can anyone help
 
F

Frank Kabel

Hi
do you need all individual entries or do you only want the
sum of them. In the latter case use SUMIF for this
 
D

Domenic

Hi,

I'm not sure if this is what you want, but here goes... Assuming for
simplicity sake,

Sheet 1
---------

Part Number Unit Cost A Unit Cost B Unit Cost C
1 1 2 3
2 4 5 6
3 7 8 9

Sheet 2
----------

Part Number Unit Cost A Unit Cost B Unit Cost C
2 4 5 6

1) On Sheet 2, select B2:D2
2) Enter this formula using CTRL+SHIFT+ENTER
=VLOOKUP(A2,Sheet1!$A$2:$D$4,{2,3,4},0)

Is this what you're looking for?
 
Top