I am doing a VLookup with an IF an the result it is returning is True. What I am trying to dai is say
If R2 is = No Match Lookup AK2 in the range A:AB column 5 if found return the answer but if it's not there I want it to return Not Found
=ISERROR(IF(R154="No Match",VLOOKUP(AK154,X:AB,5,0),"Not Found"))
What am I doing wrong?
Thanks in advance