Returning multiple values for a lookup

[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

 

[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

 

[cfincham]

I need individual entries

 

[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 B22
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?

 

[Dave Peterson]

Maybe a user defined function?

http://groups.google.com/[email protected]

There's a link to David McRitchie's site in that post if you're new to macros.