Lookup up part number in 2nd xls, transfer price across

I have two excel spreadsheets. Both have part numbers and prices, but are displayed in a different order. Is there a way to:

- Do a VLookup on "part number" from first spreadsheet (say B28) to the second (say D5)
- Once found, transfer the price in first spreadsheet (say D28) to the second (say F5)

I'd be grateful for any help!

Simon

Originally Posted by wibbler

I have two excel spreadsheets. Both have part numbers and prices, but are displayed in a different order. Is there a way to:

- Do a VLookup on "part number" from first spreadsheet (say B28) to the second (say D5)
- Once found, transfer the price in first spreadsheet (say D28) to the second (say D7)

I'd be grateful for any help!

Simon

Hi,

the result of the formula will be in the cell the formula is in, but in D7 of the 2nd,

=VLookup(D5,Sheet1!B:D,3,False)

should go close

note D5 as per the q, would normally be B7

=VLookup(B7,Sheet1!B:D,3,False)

would be more normal
---