If you send me your email address I'll be happy to send you the xl2000
file in which it works.

Alan Beban

Random wrote:
I could not get it to work in Excel 2000 either... Tried entering it
as an array, still didn't work.. I did, however get this to work for
your needs.....

=VLOOKUP($H$10,B:D,2,FALSE)&IF(ISERROR(VLOOKUP($I$ 10,B:D,3,FALSE)),"",VLOOKUP($I$10,B:D,3,FALSE))


Hope this helps.



On Thu, 07 Aug 2003 01:02:01 -0700, Alan Beban
wrote:


It works in xl2000; shall I email you the file?

Alan Beban

Patrick Molloy wrote:

this does not work for me :(
Excel XP

Patrick Molloy


-----Original Message-----
=VLOOKUP(H10,B:D,{2,3}) array entered into a 2-column row

Alan Beban

Loz wrote:


Hi,

I was hoping someone could help me with a problem I

have


please. I know (hope) it isn't too complicated, but I

just


can't do it. My logic isn't computing. }:-s

I have 2 labels. $H$10 & $I$10.
I need code to read H10 and find it in Col B and

return


the contents of Col C (Path) & Col D (Filename).
Then, if there is a label in I10 do the same.

I look forward to any assistance
Thank you!
Loz

.