Help

[aducutlas]

I'm trying to use the Vlookup function to pull data in from on
speadsheet into another.....but I have trouble using the function...Ca
anyone assist

 

[Juan Pablo González]

Can you post the formula that you have tried ? but the synatx should be
something like

=VLOOKUP(A1, Sheet2!$A$1:$C$100,3,0)

if its from another sheet in the same book, or

=VLOOKUP(A1, [Book2.xls]Sheet2!$A$1:$C$100,3,0)

if its in another book.

The Paste Function wizard should be really useful to let Excel give you the
right syntax.

 

[Ron de Bruin]

Example for using Vlookup within a other closed file

=VLOOKUP(A1,'C:\Data\[a.xls]Sheet1'!$A$1:$B$25,2,FALSE)

 

[Bob Phillips]

=IF(ISNA(VLOOKUP(A1,Sheet2!A1:C100,2,False),"",VLOOKUP(A1,Sheet2!A1:C100,2,F
alse))

will pull back the 2nd column from the lookup table, will do an exact match
on the lookup table if it is not in order (sometimes this may not be what is
required), and substitutes a blank if no match is found.