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
Tried using the IF(ISERROR(, but not successful
=If(Vlookup(a6, feb! A:E, 5, false)=E6, "OK", "New Movement").
Many thanks
M