Hi,

I was looking at doing a formula like the below;

=IF(ISNUMBER(SEARCH(”P”,D19,3)),(VLOOKUP(D19,'Rate s Summary '!A$2:Q$1573,2,0)),D19)

Basically, I have a code "QAPLI0" in cell D19. What i want to do is convert this to a QAR code which is what my Vlookup is for. Only problem is that when i already have a QAR code in the cell D19 it still brings me back a QAP instead of leaving it was whats already in the cell D19 which is what i though i had down as the "value if false" part of the IF statement.

Am i making sense? I tried to use a FIND instead of SEARCH but got the same result. Am i missing something here?

Any help would be great.

Thanks
Jon

Attached Files

excel help.xlsx (78.3 KB, 11 views)