Returning a blank cell rather then #N/A (Lookup)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,,

I’m guessing this is an easy one for you folks in the know, I’ve looked at
past posts but still confused..!!
I’m using the following function (not sure if it’s the best one) too simply
copy the contents of cell A1 to B1 (so their duplicate cells)

=LOOKUP(A1,B1)

I need to add the part of the formula (“ “) which will return a blank cell
in Row B if any of the cells are blank in Row A (currently it’s returning
with #N/A).
I’ve currently been able to get round this by placing a single ‘ character
in Row A which appears blank in both Row A and B but this may cause me
conflictions later in my exercise.

Thanks in Advance.. Monk
 
If you just want to copy the contents of cell A1 into cell B1, in cell
B1 you can use
=A1

This will avoid the whole N/A problem.
 
Back
Top