Hello Gentlemen,

Both versions work. I understand how the following eqution works:
=INDEX(A1:A10,MATCH(2,1/(1-ISBLANK(A1:INDEX(A1:A10,MATCH(C1,B1:B10,0),1)))))

I am wondering how this equation works:

=LOOKUP(REPT("Z",255),A1:INDEX(A1:A65535,MATCH(K50 ,B1:B65535,0)))

How does the REPT factor in to the equation to allow the response to be
returned. I understand the equation up until this point.

Thanks for all the help.

Dan


"Biff" wrote:

Hi!

Try this:

=LOOKUP(REPT("Z",255),A1:INDEX(A1:A65535,MATCH(K50 ,B1:B65535,0)))

Biff

"Dan" wrote in message
...
I have two columns with multiple sets of data, based on the entered value I
need the corresponding header returned.

For example:
Column A Column B
Apples Green
Red
Granny Smith
Mutsu
Red Delicious

Oranges Naval
Manderin
Clementine
Tangerine

Now based on a response in another sheet I need to return either "Apple"
or
"Orange".

=INDEX('Fruit'!A1:A65535,MATCH(K50,'Fruit'!B:B6553 5,0)) will work if I
copy
Apple next to each apple type, but for other items the list of options can
grow dramatically.

Thanks

Dan