Variable Column_Index_Number in VLOOKUP Formula

[Gtabtr1]

ID #	Name	Date 1	Date 2	Date 3
29	John	1/9/2011	5/12/2014
42	Bill	6/18/2014	8/16/2017	11/10/2017
112	Jane	9/15/2018

<tbody>
</tbody>

Hi Board! Need your help again. Haven't been able to find an answer that works.

I need to do a vlookup to find the ID# the find the last date in that row.

Thank you in advance.

 

[steve the fish]

Table in A1:E4. ID in G1. Try this:

=LOOKUP(10^10,INDEX($C$2:$E$4,MATCH(G1,$A$2:$A$4,0),0))

 

[GR00007]

Do you mean the last populated date of the three? If so, then =IF(E2<>"",E2,IF(D2<>"",D2,C2)) may work.

ID #	Name	Date 1	Date 2	Date 3	Last Date
29	John	1/9/2011	5/12/2014		5/12/2014
42	Bill	6/18/2014	8/16/2017	11/10/2017	11/10/2017
112	Jane	9/15/2018			9/15/2018

<colgroup><col span="2"><col span="2"><col span="2"></colgroup><tbody>
</tbody>

 

[Gtabtr1]

Thank you Steve the Fish. Worked perfectly!!!