Thank you very much... This is what I was looking for...

Tuncay


T. Valko wrote:
Try this:

A10 = lookup value

I'm assuming your table is in the range A1:E5.

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(A1:A5,MAX((B1:E5=A10)*(ROW(B1:E5))),0)

Biff

wrote in message
ups.com...
Thanks for the suggestion but in this case the value that I was looking
for is in the cell E3 and therefore I want to get the value in cell A3
as a result. The problem is that I don't know which column or row the
value I am looking for is in. The value is somewhere in the table
B1:E5.

Teethless mama wrote:
=INDEX(A1:A5,MATCH("*C11524-1*",B1:B5,0))


" wrote:

I have a table in my worksheet as follows:

'+1V5' C12809-1 C12810-1
'+1V5_FPGA_dec' R12805-1 C12820-1 TP12844-1 C12821-2
'+1V8' TP11847-1 L11804-2 U11800-6 C11524-1
'+1V8' C11533-1 C11820-1 R11010-1 C11824-1
'+1V8_7020_PLL' C11826-1 U11500-N23 U11500-N22 C11801-2

I have the value I want to find stored in another worksheet. Lets say
the value is "C11524-1". How do I search for this value in the current
worksheet to get the cell value of the first column in the same row
where the value is found. In the above example I should be able to get
'+1V8' as a result.

I couldn't figure out a way to do this using vlookup or index/match.

Any help will be greatly appreciated.

Tuncay