(Msg. 1) Posted: Mon Oct 13, 2008 2:31 pm
Post subject: VLOOKUP Not seeing all source links but find does Archived from groups: microsoft>public>excel>links (more info?)
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.
(Msg. 2) Posted: Tue Oct 14, 2008 3:08 pm
Post subject: Re: VLOOKUP Not seeing all source links but find does [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Fri Oct 17, 2008 7:45 pm
Post subject: RE: VLOOKUP Not seeing all source links but find does [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
>
>
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office