Using lookup across workbooks


G

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
 
Ad

Advertisements

F

Frank Kabel

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

Paul Lautman

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

Advertisements

P

Paul Lautman

I think you're looking for something like:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top