Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |