Hi

I have problems with a formula workbook and I was given by an ex colleague a formula for one sheet of which is shown as below

=IFNA(IF(E2=VLOOKUP(A2,WATFORD!A:E,5,),"OK","N/A"),"N/A")

What I have is another worksheet that has a slightly different formula in and I need to amend it so it does the same sort of thing as the one above but looking in both pages as it does now.

=IF(E2=IFNA(VLOOKUP(A2,TABLEAU!A:E,5,FALSE),0),"OK",IF(E2=IFNA(VLOOKUP(A2,PREVREC!A:E,5,FALSE),0),"Previous","N/A"))