Thread: Vlookup problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
dk
 
Posts: n/a
Default Vlookup problem

we are getting a wording of (#REF!) insteadd of getting the description of
the feild even though there a text data in the refrenced field
ex:=VLOOKUP(B10,'C:\Documents and Settings\Administrator\My
\[calling_.XLS]Customers'!$A$1:$D$58,5,FALSE)

Also we have 2 times the same name in column a ex row a1; has data "Joe" row
a21; has data "Joe" from were will all data filled if were going to enter in
cell b10 =CONCATENATE([calling_.XLS]Customers!$A$21)