=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