Alright so i did a vlookup and have a long list of numbers in cloumn A and the results of the vlookup in column B, Some of the values in column B say "#N/A"
I want to return the value in cloumn A if Column B says "#N/A" and if it doesnt say NA i want the cell to remain blank.
I tried =if(B1="#N/A",A1) this still returns an #N/A and i dont know how to proceed.
Further more id like to get rid of those blanks between the numbers if at all possible but i can do this manually if there is no easy way to do it.
Thanks in advance!