Using lookup across workbooks

[Guest]

Hi,
Two workbooks:
Workbook 1, Sheet 1 contains the following data:

A1: First name B1: Revenue
A2: Alex B2: 5.00
A3: Bob B3: 7.00
A4: Charlie B4: 2.50

The second workbook, Sheet 1 has the following headings, with the First Name
data in a different order:

A1: First name B1: Revenue
A2: Charlie
A3: Bob
A4: Alex

I want to link the workbooks using a lookup function so that column B
autopopulates with revenue figures - without re-organising the order.

Any ideas would be much appreciated.

Thanks

Alex

 

[Frank Kabel]

Hi
in B2 on your second sheet enter
=VLOOKUP(A2,'sheet1'!$A$1:$B$100,2,0)
and copy down

 

[Paul Lautman]

He wants to look up from sheet 1 in one workbook into sheet 1 of a DIFFERENT
workbook.

 

[Paul Lautman]

I think you're looking for something like:

=VLOOKUP(A2,'[Name of second workbook]Sheet1'!$A$2:$B$4,2,FALSE)