vlookup #n/a

  • Thread starter Thread starter Parker
  • Start date Start date
P

Parker

when trying to use this formula
=vlookup(B103,"spreadsheet.xls"$a$1:$B$222,2,false) I always get the #n/a in
the field I want the lookup to display! Any Ideas??
 
Hi
your reference "spreadsheet.xls"$a$1:$B$222 is not valid
maybe something like
=vlookup(B103,'[spreadsheet.xls]sheet1'!$a$1:$B$222,2,false)
would work, if spreadsheet.xls is open and the data is on sheet1
 
Try this syntax:
=VLOOKUP(B103,'d:\path\[spreadsheet.xls]Worksheet'!$A$1:$B$222,2,FALSE). You
can either type it in or build it by pointing and clicking.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com
 
Back
Top