Help

  • Thread starter Thread starter aducutlas
  • Start date Start date
A

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
 
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.
 
Example for using Vlookup within a other closed file

=VLOOKUP(A1,'C:\Data\[a.xls]Sheet1'!$A$1:$B$25,2,FALSE)
 
=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.
 
Back
Top