IF and VLOOKUP
Well, I think you should change the A$1 in the formula to A$4, and the
to =, but then it should do what you want it to do.
Hope this helps.
Pete
On Sep 18, 3:14*pm, Teri wrote:
Not sure if I'm using the correct functions, but here is my formula:
=IF(VLOOKUP(E46,'SVC LVL'!A$1:D$29,4,FALSE)F46,"Yes","No")
E46 = Service Level
A4:D29 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.
|