Hi!
Trying to get a formula to work if a vlookup is not NA.
I know it's something similar to this:
This is in a cell in C24 on a sheet called "Payment Grid"
In simple terms: On the Payment Grid Sheet: I want to sum rows C3:C22 in cell C24 if the vlookup from cells B3:B22 to the quarter lookup is not NA.
Hope that makes sense? Maybe this isn't even possible but I feel like it should be somehow!
Trying to get a formula to work if a vlookup is not NA.
I know it's something similar to this:
This is in a cell in C24 on a sheet called "Payment Grid"
Code:
=SUMIFS(C3:C22,B3:B22,not(isna(vlookup(B3,'Quarter Lookup'!B:C,2,0)
In simple terms: On the Payment Grid Sheet: I want to sum rows C3:C22 in cell C24 if the vlookup from cells B3:B22 to the quarter lookup is not NA.
Hope that makes sense? Maybe this isn't even possible but I feel like it should be somehow!