Need Formula to pull the content on a cell

[ediancoc]

I have about ten columns with different type of expenses, on one of these columns there will be one expense category. I need a formula that pulls the value on that cell

Cleaning Supply	Empty Cell	Empty Cell	Formula that pulls Cleaning Supply, the only cell with Value

<tbody>
</tbody>

 

[Michael M]

Can you give us a better example, with data would be nice !!!

 

[ediancoc]

Can you give us a better example, with data would be nice !!!

1	Cleaning Supply	Empty Cell	Empty Cell	formula to pull or equal to Cleaning Supply
2	Empty Cell	Office Supply	Empty Cell	Formula to pull or equal to office supply
3	Empty Cell	Empty Cell	Guest Supply	Formula to pull or equal to Guest Supply

<tbody>
</tbody>

<colgroup><col span="7"><col><col></colgroup><tbody>
</tbody>

 

[Peter_SSs]

See if you can adapt this to your actual ranges.

Excel Workbook
	A	B	C	D
1	Cleaning supply			Cleaning supply
2		Office supply		Office supply
3			Guest supply	Guest supply
Get Value