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

Hi,,

Im guessing this is an easy one for you folks in the know, Ive looked at
past posts but still confused..!!
Im using the following function (not sure if its 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 its returning
with #N/A).
Ive 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

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

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.

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

"Dave O" wrote:

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.