Using Match on multiple columns

[mambonumber5]

I'm trying to locate a number within an array of several columns and then look up a cell to the left of the array on the same row where the value has been located. For example:

	A	B	C	D
1	doctor	3.2	8	16.73
2	nurse	14.7	16.73
3	purse	1.09	20.3

<tbody>
</tbody>

I want to look up D1 in B1:C3 and trace it so that it will return "nurse". I'm trying to use:

Index(A1:A3,Match(16.73, B1:C3, 0))

I would like to do this with a formula rather than by the creation of a separate table to analyze all the columns one by one. Ideas?

Much appreciated, thanks

 

[pgc01]

I'm glad it helped.

 

[goong522]

Hi - stumbled upon this while researching for a resolution to my issue
Is there way to do a partial search for the below? say instead of looking the exact value of 16.73 in G1, say G1 was 16.1, and it return "nurse" (since C2=16.73, which is "close to my 16.1 specified value). Side note, my values will be text and not numerical values, which is the need for looking for "partial string match".

Thank you dreid, it may be just it.

In that case, this is another solution.

In H1:

=IF(COUNTIF($B$1:$E$5,G1),INDEX(A:A,MAX(INDEX(($B$1:$E$5=G1)*ROW($B$1:$E$5),))),"Not found")

Copy down

	A	B	C	D	E	F	G	H	I
1	doctor	3.2	8	27.64	24.41		16.73	nurse
2	nurse	14.7	16.73	19.96	24.2		23.68	moon
3	purse	1.09	20.3	20.72	26.06		29.86	ant
4	ant	29.86	19.6	25.66	23.18		1.23	Not found
5	moon	24.11	24.08	22.94	23.68
6
[Book1]Sheet4

<tbody>
</tbody>