Error Message on Formula returning #Value

[Hawaii Movie Guy]

Looking for help on a relatively simple (i thought) formula for doing two things in one cell. I have a 2 sheet workbook. On Sheet 1 i have two cells (A1 and A2) with NAMES OF EMPLOYEES in them. I want to transfer that info from Sheet 1 to Sheet 2 to let's say Cell A50 on Sheet 2 but with the following parameters: if both cells with names on Sheet 1 are blank, then Cell A50 on Sheet 2 would also remain blank. If both cells on Sheet 1 contain names, then Sheet 2 would only list the name in A1. If cell A2 is blank on Sheet 1, then Sheet 2 would list the name in A1 from Sheet 1. (hope this makes sense)

Currently i'm using the formula: =if('Sheet1'!a2<>0,'Sheet1'!a2,'Sheet1'!a1) which returns a 0 on sheet 2.

Any suggestions on getting that 0 to not appear if both a1 and a2 are blank on Sheet 1?

thanks

 

[MARZIOTULLIO]

Hi

A50 =IF(AND(Sheet1!A1="",Sheet1!A2=""),"",IF(AND(Sheet1!A1<>"",Sheet1!A2<>""),Sheet1!A1,IF(Sheet1!A2="",Sheet1!A1)))

 

[Aladin Akyurek]

In A50 of Sheet2 enter:

=IF(COUNTIFS(Sheet1!$A$1:$A$2,"?*")>0,Sheet1!$A$1,"")