Hi there,
I'm using a formula which is getting details from three columns, however there is a point where its returning #VALUE!
So my sheet looks like this:
Column O & P:
Country Names (O) and City Names(P)
Column Z:
I only enter the letter X in all the cells of the whole column.
Column AJ:
Uses the following formula;
Column AU:
Just equals the value from column AJ
At the moment, column AJ is showing #VALUE! when there is an "X" in column Z but theres no data in either column O or P.
Not using conditional formatting as that wont help with what i want to do, how do i get the cell to return blank instead of #VALUE!
??
Many thanks
Bookmarks