Formula to consolidate two different columns

[gigglesxx]

Hi,

I am trying to create a formula which looks at two different columns (1 and 2 in this example) and returns the value if there is one in either column 1 or column 2. And if both columns are empty, then leave the cell empty.

For example for the first row, the formula would return $205 and for the second row it would return $204. I am trying to consolidate the two columns into the one

Any help would be much appreciated!

[TABLE="width: 500"]
<tbody>[TR]
[TD]average weighted rate (all)[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]$205[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$204[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]$216[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$220[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$290[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$290[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$300[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 401"]
<colgroup><col><col><col></colgroup><tbody></tbody>[/TABLE]

 

[Yongle]

Re: Formula to consolidate two different columns. help!

Columns A,B,C
Excel 2016 (Windows) 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD][/TD]
[TD]

Result​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD]

$205​

[/TD]
[TD]

$205​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]

$204​

[/TD]
[TD][/TD]
[TD]

$204​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD]

$216​

[/TD]
[TD]

$216​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]

$200​

[/TD]
[TD][/TD]
[TD]

$200​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]

$220​

[/TD]
[TD][/TD]
[TD]

$220​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]

$300​

[/TD]
[TD][/TD]
[TD]

$300​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]

$290​

[/TD]
[TD][/TD]
[TD]

$290​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]

$290​

[/TD]
[TD][/TD]
[TD]

$290​

[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]

$300​

[/TD]
[TD][/TD]
[TD]

$300​

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet2[/TD]
[/TR]
</tbody>[/TABLE]

Formula in C2 copied down
Excel 2016 (Windows) 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: #FFFFFF"]
[TD]

=IF(ISBLANK(A2),B2,A2)​

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet2[/TD]
[/TR]
</tbody>[/TABLE]