Variable Column_Index_Number in VLOOKUP Formula

[Gtabtr1]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]ID #
[/TD]
[TD]Name
[/TD]
[TD]Date 1
[/TD]
[TD]Date 2
[/TD]
[TD]Date 3
[/TD]
[/TR]
[TR]
[TD]29
[/TD]
[TD]John
[/TD]
[TD]1/9/2011
[/TD]
[TD]5/12/2014
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]42
[/TD]
[TD]Bill
[/TD]
[TD]6/18/2014
[/TD]
[TD]8/16/2017
[/TD]
[TD]11/10/2017
[/TD]
[/TR]
[TR]
[TD]112
[/TD]
[TD]Jane
[/TD]
[TD]9/15/2018
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]







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.
[TABLE="width: 414"]
<colgroup><col span="2"><col span="2"><col span="2"></colgroup><tbody>[TR]
[TD]ID #[/TD]
[TD]Name[/TD]
[TD]Date 1[/TD]
[TD]Date 2[/TD]
[TD]Date 3[/TD]
[TD]Last Date[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD]John[/TD]
[TD="align: right"]1/9/2011[/TD]
[TD="align: right"]5/12/2014[/TD]
[TD][/TD]
[TD="align: right"]5/12/2014[/TD]
[/TR]
[TR]
[TD="align: right"]42[/TD]
[TD]Bill[/TD]
[TD="align: right"]6/18/2014[/TD]
[TD="align: right"]8/16/2017[/TD]
[TD="align: right"]11/10/2017[/TD]
[TD="align: right"]11/10/2017[/TD]
[/TR]
[TR]
[TD="align: right"]112[/TD]
[TD]Jane[/TD]
[TD="align: right"]9/15/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9/15/2018[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gtabtr1]

Thank you Steve the Fish. Worked perfectly!!!