How would I automatically search: Price List

[thisandthat]

Hi

I have one sheet that has a list of part numbers (sheet 1)
A
1 123
2 231
3 123


In a different sheet I have prices (sheet 2)
A B
1 123 $20
2 231 $5
3 321 $0.5


How would I automatically search sheet 2 for the matching part number and put the price next to the part in sheet 1


Thanks

[Cutter]

In A2 place a VLOOKUP() function

=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,0)

change the Sheet2 to your actual sheet's name and change the 100 to the last row of your list on that sheet. It is preferable to name your list's name and use that name in your formula.

With the corrected references in the formula you can drag it down as far as needed.

[thisandthat]

Thanks

Now same question but is it possible to do it from a different file?

Thanks in advance

[Cutter]

Give it a try.

[thisandthat]

Sweet deal it works!

[Cutter]

Did you try it with the source document closed?