VLOOKUP minus VLOOKUP (Dates)

[NJS1982]

Hi, wondered if anyone can help me work something out.
I have a formula, below:

(=if(A2="","",if(E2=1, VLOOKUP FORMULA - VLOOKUP FORMULA, 0)

The two VLookups are dates, elsewhere in the sheet. But I don't think I am able to nest two VLOOKUPS like this...does anyone know for sure?

 

[Joe4]

You should be able to do that just fine, as long as both VLOOKUPS return actual date values and not any errors (or text entries).

 

[NJS1982]

Hmmm, but it doesn't work?

=IF(A2="","",IF(E2=1,VLOOKUP(A2,'GMS Overarching Report'!A1:AN3000,MATCH("App Recd Date",'GMS Overarching Report'!$A$1:$AD$1,0)-VLOOKUP(A2,'GMS Overarching Report'!A1:AN3000,MATCH("First Decision Date",'GMS Overarching Report'!$A$1:$AD$1,0),0))))

 

[NJS1982]

If I try INDEX, it seems to work...?

=IF(A2="","",IF(E2=1,INDEX('GMS Overarching Report'!C:C,MATCH(A2,'GMS Overarching Report'!A:A,0))-INDEX('GMS Overarching Report'!B:B,MATCH(A2,'GMS Overarching Report'!A:A,0)),""))

 

[Joe4]

Hmmm, but it doesn't work?

Did you confirm that each VLOOKUP works independently on its own first?
If they do, then you should be able to use them in the larger formula.

INDEX/MATCH is a good substitute for VLOOKUP, are often time more efficient. So if that is working, I would just say go with that.