If I have a vlookup function and it returns #N/A, How would i need to rewrite the function to make "" appear instead of #N/A, I know I need to use IF, but I can't get it to work out.
J5 =VLOOKUP(H5,'CASS Data'!$D$598:$I$614,2,FALSE)
That is the vlookup I am using.
Ben
J5 =VLOOKUP(H5,'CASS Data'!$D$598:$I$614,2,FALSE)
That is the vlookup I am using.
Ben