Using an IF condition in a VLOOKUP formula

[meppwc]

I am trying to figure out logic to combine an IF condition into the outcome of a VLOOKUP formula
Column A of "Worksheet A" is a list of serial numbers
Column B of "Worksheet A" is where a formula will be that looks for the value in column A against a table of serial numbers in column A of "Worksheet B" and display the value found

=VLOOKUP(A2,'Worksheet B'!$A$1:$M$12,1,FALSE)

The formula above in cell B2 of Worksheet A works correctly.
But in column 13 of Worksheet B (column M), the cells may be blank or may contain the word "EXCEPTION"

I want to modify the above formula to display "EXCEPTION" if the word exists. If no word exists then the formula will return the value searched on is it currently does.

 

[Joe4]

Try:

=IF([COLOR=#333333]VLOOKUP(A2,'Worksheet B'!$A$1:$M$12,13,FALSE)="EXCEPTION","EXCEPTION",[/COLOR][COLOR=#333333]VLOOKUP(A2,'Worksheet B'!$A$1:$A$12,1,FALSE))[/COLOR]

 

[meppwc]

Thanks Joe4.......perfect !!!

 

[Joe4]

You are welcome!