T
Teri
Not sure if I'm using the correct functions, but here is my formula:
=IF(VLOOKUP(E46,'SVC LVL'!A$1$29,4,FALSE)>F46,"Yes","No")
E46 = Service Level
A429 is the table of codes, Column A is the code, Column D is the
guaranteed number of days
F46 = Transit Days
The answer I am looking for: if F46 (Transit Days) is greater than the
corresponding number of days in the VLOOKUP, the answer should be No.
Otherwise, the answer should be Yes.
=IF(VLOOKUP(E46,'SVC LVL'!A$1$29,4,FALSE)>F46,"Yes","No")
E46 = Service Level
A429 is the table of codes, Column A is the code, Column D is the
guaranteed number of days
F46 = Transit Days
The answer I am looking for: if F46 (Transit Days) is greater than the
corresponding number of days in the VLOOKUP, the answer should be No.
Otherwise, the answer should be Yes.