Does your hyperlink include a text label? A8 should contain the
equivalent of =HYPERLINK("some jpeg";1216) or, if 1216 is a label, "1216".
I think there's something wrong with your formula as posted (probably
double pasting):
=IF(ISNA(VLOOKUP(A8; Jobs.$J$4:$P$1010; 7; 0)); IF(ISNA(VLOOKUP(A8;
Ravy.$J$4:$P$1010; 7; 0)); ""; VLOOKUP(A8; Ravy.$J$4:$P$1010; 7; 0));
VLOOKUP(A8; Jobs.$J$4:$P$1010; 7; 0))
should be :
=IF(ISNA(VLOOKUP(A8; Jobs.$J$4:$P$1010; 7; 0)); ""; VLOOKUP(A8;
Jobs.$J$4:$P$1010; 7; 0))
Anyway, what are you doing working this late? (I've got no excuse
except for me it isn't work.)
Cheers (and good night)
James Elliott wrote:
Thanks Terry
I hear what you are saying about using the "Path" vs "Target" fields. As I am looking up
a completely separate document, I fill in the "Path" field.
This is the formula which works if it finds "1216" but bombs out if 1216 had an
embedded hyperlink:
=IF(ISNA(VLOOKUP(A8; Jobs.$J$4:$P$1010; 7; 0)); IF(ISNA(VLOOKUP(A8; Ravy.$J$4:$P$1010; 7;
0)); ""; VLOOKUP(A8; Ravy.$J$4:$P$1010; 7; 0)); VLOOKUP(A8; Jobs.$J$4:$P$1010;
7; 0))
So, if looking up A8 (let's say "1216") gives us "N/A", then print null (blank
field);
If A8="1216" is found then look up the corresponding job number.
It workd fine. However, if I select 1216 in the Jobs sheet and embed a
hyperlink to the invoice JPEG, VLOOKUP can no longer find it and the recod
disappears from my Invoice sheet.
Regards, Jim
--
If you're seeking, check out http://www.rci.org.au
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
