Help with Error

[DKRbella0814]

column M = PO or Standard

=IF(J2="","LT","PO")

column N = PO or Lead Time (Days)

=IF(OR(L2="lt",L2="po",VLOOKUP(B2,'Vendor List'!$A$4:$D$73,4,FALSE),"PO")

Please help me figure out why col N is returning a #N/A error; the lookup value is in the lookup table in the exact format as in B2...I can't figure this out. Maybe a formatting issue?

 

[schielrn]

Do either of these work?

=IF(OR(L2="lt",L2="po",VLOOKUP(B2+0,'Vendor List'!$A$4:$D$73,4,FALSE),"PO")

or:

=IF(OR(L2="lt",L2="po",VLOOKUP(B2&"",'Vendor List'!$A$4:$D$73,4,FALSE),"PO")

What is the value in B2?

 

[DKRbella0814]

Neither of those worked. I believe that my formula was written correctly; however, I'm not sure why it is returning the error.