Nested IF with VLOOKUP functions

[ifu06416]

Hello,

Im trying to build a function that will pull one of 4 possible dates from a table. Ive managed to build a formula that will pull through 2 dates but i cannot figure out how to add the other 2 dates.

I have four columns which may or may not have a date in them. These dates are in a hierarchy with whatever date is in the column farthest to the right taking precedent over the others. Im trying to build a function that will look through each of these columns returning the date from the column furthest to the right.</SPAN>

So far i have got the following but it only considers the first two columns.

IF(VLOOKUP(B9,'[XXX.xlsx]Loans'!$P:$BI,18,0)="",VLOOKUP(B9,'[XXX.xlsx]Loans'!$P:$BI,28,0),VLOOKUP(B9,'[XXX.xlsx]Loans'!$P:$BI,18,0))

Can anyone help modify this to include the two remaining columns which are numbered 38 and 46 on the VLOOKUP table.

Thank you

John

 

[Chrisdontm]

I think I have it like you want it.
If not, it shouldn't take much alterations...

If I understand you correctly, you would rather have the far right answer.
( That is how I set up the formula )
Also, I am assuming that you would like it to be blank until there is an answer...

Try this;

=IF(VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,46,0)="",IF(VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,38,0)="",IF(VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,28,0)="",IF(VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,18,0)="",VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,18,0)),VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,28,0)),VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,38,0)),VLOOKUP(B9,[XXX.xlsx]Loans!$P:$BI,46,0))


Basically that is putting an IF formula inside an IF formula inside an IF formula inside an IF formula...
Chris Mc.

 

[ifu06416]

Ahhh, excellent.

You've understood me just right. Looking at it now it makes more sense but trying to get there from scratch just wasnt working.

Thanks for the help.

John