Reverse Lookup Function Error

[Simonc64]

Hi All

I have just discovered this function and have used it successfully previously, but this has me stumped. It must be something to do with how the =IF(AND treats the LOOKUP function?

Assume all the statements in the IF statement are correct, AND that the lookup vale of "IN" exists in both the specified ranges AND the result equals the value in cell T14 - why does this formula return an "X" please. (I know why it does, but i wasnt expecting the formula to fail before this point)

=IF(AND(U14="even",Z14="Y",LOOKUP(2,1/($AK$2:$AK$12="IN"),$AJ$2:$AJ$12))=T14,VLOOKUP("IN",$AK$2:$AL$12,2,0),"X")

Thanks in advance!

Simon

 

[Fluff]

You have the closing bracket for the AND in the wrong place. It should be

=IF(AND(U14="even",Z14="Y",LOOKUP(2,1/($AK$2:$AK$12="IN"),$AJ$2:$AJ$12)=T14),VLOOKUP("IN",$AK$2:$AL$12,2,0),"X")

 

[Simonc64]

You have the closing bracket for the AND in the wrong place. It should be

=IF(AND(U14="even",Z14="Y",LOOKUP(2,1/($AK$2:$AK$12="IN"),$AJ$2:$AJ$12)=T14),VLOOKUP("IN",$AK$2:$AL$12,2,0),"X")

Thanks fluff, much appreciated, and so emabarrassingly simple! Been looking at too long i think! thanks again!

 

[Fluff]

Glad to help & thansk for the feedback.