I must apologize here. I have reread Alan's post as well and found
out that it does work in Excel 2000 quite well. I am very new to the
array idea with excel and did not try to enter it into a two column
array of cells. Thanks for the insight there. I enjoy learning
something new. Can anyone recommend a site where the array functions
are explained in detail?

Thanks for your patience.


On Thu, 07 Aug 2003 13:10:50 -0700, Alan Beban
wrote:

After corresponding with Mark Bigelow, and reviewing this thread,
particularly
Random's last post below, it finally becomes clear--the OP's original
specification is not clear. I posted a "solution" that returned to two
cells
the two values from the OP's Columns C and D for the value in the OP's
Cell H10.

Random posted a formula that returns to a single cell the concatenated
values from the OP's Column C for the OP's Cell H10 and from the OP's
Column D for the OP's Cell I10.

From rereading the original post, it seenms the OP wanted two values
returned corresponding to the OP's Cell H10, and an additional two
values corresponding to the OP's Cell I10.

Perhaps the OP could clarify what's supposed to be returned to where,
concatenated with what :_)

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


.