LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup problem puiuluipui Excel Discussion (Misc queries) 2 February 5th 06 05:46 PM
Vlookup problem with Date Time normajmarsh Excel Worksheet Functions 0 February 3rd 06 07:33 PM
vlookup Problem marksuza Excel Discussion (Misc queries) 3 December 22nd 05 03:40 PM
VLOOKUP Problem Tosca Excel Worksheet Functions 7 July 23rd 05 10:43 PM
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? Steve Excel Worksheet Functions 0 January 30th 05 09:11 PM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"