A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

VLOOKUP Not seeing all source links but find does



 
 
Thread Tools Display Modes
  #1  
Old October 13th, 2008, 08:31 PM posted to microsoft.public.excel.links
LarryH[_2_]
external usenet poster
 
Posts: 1
Default VLOOKUP Not seeing all source links but find does

Problem linking values from one wookbook / sheet to anouther. Almost all
cells work fine but some do not, they do however if I copy/paste the lookup
value into a "search all sheets" and double click the cell in the source
sheet that contains the lookup value.

Example: Look up cell for destination file on sheet1 = 1234
Look up cell from source file on sheet2 = 1234

Both are formated as "text" but the vlookup data is not transfered until I
double click on the cell containing 1234 in the source file sheet2 then it
works fine until I update the file again.



  #2  
Old October 14th, 2008, 04:08 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default VLOOKUP Not seeing all source links but find does

Sorry, Larry, but I am not quite following you.
Please could you clarify:
- which version of Excel
- whether source and destination workbooks are open, or only
destination
- what is the calculation mode
- what is the formula containing the link
- what value is it showing
- what value is in the cell you expect to be referenced by the link.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3  
Old October 18th, 2008, 03:45 AM posted to microsoft.public.excel.links
ShaneDevenshire
external usenet poster
 
Posts: 2,232
Default VLOOKUP Not seeing all source links but find does

Hi,

This often occurs when there is a data type mismatch between the item you
are looking up and the first column of the lookup table. If they are numbers
they must both be numbers, if the are number displayed as text they must both
be text.

Find on of the offending items and try the =ISTEXT(A1) function or the
ISNUMBER(A1) function on both the number you are looking up and that value in
the first column of the lookup table.

--
Thanks,
Shane Devenshire


"LarryH" wrote:

Problem linking values from one wookbook / sheet to anouther. Almost all
cells work fine but some do not, they do however if I copy/paste the lookup
value into a "search all sheets" and double click the cell in the source
sheet that contains the lookup value.

Example: Look up cell for destination file on sheet1 = 1234
Look up cell from source file on sheet2 = 1234

Both are formated as "text" but the vlookup data is not transfered until I
double click on the cell containing 1234 in the source file sheet2 then it
works fine until I update the file again.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.