vlookup

[rcharter]

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

 

[rcharter]

thanks, I found the answer in another question.

 

[RCHARTER]

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

 

[Katherine Coombs]

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

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]

Thanks Katherine, I believe that will work just fine.