vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I am trying to ascertain whether vlookup can be used to import data from a different workbook, and if so what is the syntax. Thanks
 
Hello again. If anyone could post me an example of a vlookup formula to import data from a different workbook I would be very thankful
Rcharter
 
Hi Rcharter,

A vlookup doesn't import data, per se. It provides a way to lookup data in
one range and return resultant data from another range.

The syntax is:
=VLOOKUP(A1,[Book3.xls]Sheet1!$A$1:$B$2,2,FALSE)

where:
- A1 is the cell in the current worksheet that you're looking up.
- Book3 is the name of the other workbook
- Sheet1 is the name of the worksheet in Book3
- $A$1:$B$2 is the range in Book3, Sheet1 that contains the table array

Is this what you're trying to achieve?

Cheers,
Katherine

RCHARTER said:
Hello again. If anyone could post me an example of a vlookup formula to
Click to expand...
import data from a different workbook I would be very thankful.
 
Back
Top