IF and VLOOKUP

[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.

 

[Pete_UK]

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

 

[Teri]

Whoops! The codes are in A149. The problem I'm getting is:

Example: 3D = 6

When I use my formula and a 3D shipment comes up with 6 days, it says No.

 

[Pete_UK]

Well, perhaps the 6 in your table is really just a text value rather
than an actual number. You could try this to see if it improves
things:

=IF(VLOOKUP(E46,'SVC LVL'!A$1$29,4,FALSE)+0>=F46,"Yes","No")

The +0 converts a text number into a proper number.

Hope this helps.

Pete

 

[Teri]

OMG!! That's it!! Thank you so, so much

Well, perhaps the 6 in your table is really just a text value rather
than an actual number. You could try this to see if it improves
things:

=IF(VLOOKUP(E46,'SVC LVL'!A$1$29,4,FALSE)+0>=F46,"Yes","No")

The +0 converts a text number into a proper number.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Teri - thanks for feeding back.

Pete