2 IFs with wildcards and a LOOKUP

[sarawall]

Hi - I created a lookup table but need some IFs thrown in the equation and can't seem to make it work:

Current formula is: =LOOKUP(B2,$L$1:$M$7)

=IF(AND(B2="S2",F2<>"132*","POSS"),IF(AND(B2="S2",F2="132*","Lockbox"),LOOKUP(B2,$L$1:$M$7)))

do I need an OR in there somewhere? or can I add a 3rd column to the lookup table to account for the "132*" variation?

Sara

[martindwilson]

do you mean

Please Login or Register  to view this content.

[sarawall]

Not quite...it doesn't work with the document type that is not S2. Thanks for replying so quickly.

[martindwilson]

it does for me what bit doesn't work?

[sarawall]

I am getting #VALUE error when I change column B. I have everything formatted as general like you. Not sure what the problem is...colum F is alpha/numeric so needs to stay the way it is. When I copied to my working spreadsheet I received a #NA error.

[martindwilson]

attach a workbook showing some with #value in
=IF(AND(B2="S2",LEFT(F2,3)<>"132"),"POSS",LOOKUP(B2,$L$1:$M$7)) would give the same result

[sarawall]

Got it...didn't change the row reference! Thanks for all your help!!! This will save checking 26,000 lines manually this month and each month forward!

Sara