# Last Lookup With INDEX MATCH

#### proficient

##### Well-known Member
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
ABCDEFGHIJ
1ABCDEFGLWO
2123415671015
3
4E
5
6Answer Should be O not E
Sheet2

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Try

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

B4 :

=LOOKUP("z",A1:Z1)

Try:

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

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

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.

Replies
9
Views
317
Replies
24
Views
597
Replies
10
Views
296
Replies
3
Views
214
Replies
3
Views
934

Threads
1,203,667
Messages
6,056,645
Members
444,879
Latest member
suzndush

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back