N/A's

[mrsushi]

Currently using a formula as per below where it checks data on another sheet and checks if it matches or not. However, if its not on the other sheet, how can the formula be amended? At the moment its producing a return of #N/A

Tried using the IF(ISERROR(, but not successful



=If(Vlookup(a6, feb! A:E, 5, false)=E6, "OK", "New Movement").


Many thanks
M

 

[Fluff]

How about

=IF(ISNA(VLOOKUP(A6,feb!A:E,5,FALSE)),"New movement",IF(VLOOKUP(A6,feb!A:E,5,FALSE)=E6,"Ok","New movement"))

 

[mrsushi]

How about

=IF(ISNA(VLOOKUP(A6,feb!A:E,5,FALSE)),"New movement",IF(VLOOKUP(A6,feb!A:E,5,FALSE)=E6,"Ok","New movement"))

Thank you fluff. It worked perfectly

 

[Fluff]

You're welcome & thanks for the feedback.