I am using vlookup function and am getting numerous #NA results back.
I am pretty sure the function is working as expected but need to check
I am trying to expand the function to bring back something more meaningful like 'no data found'
Any ideas how I can double check.
I am also getting some 0's in the results aswell
Grateful for any help, thanks