Last Lookup With INDEX MATCH

[proficient]

Dear All,
Here is my problem in below I want to extract the last result, but due to same matches I am getting wrong answer

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	A	B	C	D	E	F	G	L	W	O
2	1	2	3	4	15	6	7		10	15
3
4		E
5
6	Answer Should be O not E
Sheet2

 

[Sandeep Warrier]

Try

=INDEX($A$1:$M$1,MATCH(9.99999E307,A2:M2))

 

[bosco_yip]

B4 :

=LOOKUP("z",A1:Z1)

 

[Firefly2012]

Try:

=LOOKUP(2,1/(A2:M2),A1:M1)

 

[bosco_yip]

If you want to return the last text and numeric as per you table,

B4, formula copy down to B5

=LOOKUP(2,1/(A1:Z1<>""),A1:Z1)

Regards

 

[Aladin Akyurek]

Dear All,
Here is my problem in below I want to extract the last result, but due to same matches I am getting wrong answer

Sheet2

	A	B	C	D	E	F	G	H	I	J
1	A	B	C	D	E	F	G	L	W	O
2	1	2	3	4	15	6	7		10	15
3
4		E
5
6	Answer Should be O not E

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B4 =INDEX($A$1:$M$1,MATCH(LOOKUP(2,1/(A2:M2),A2:M2),A2:M2,0)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Try...

=LOOKUP(9.99999999999999E+307,A2:J2,A1:J1)

following your exhibit.