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 [TABLE="width: 500"]
<tbody>[TR]
[TD]Cleaning Supply[/TD]
[TD]Empty Cell[/TD]
[TD]Empty Cell[/TD]
[TD]Formula that pulls Cleaning Supply, the only cell with Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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 !!!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]Cleaning Supply[/TD]
[TD]Empty Cell[/TD]
[TD]Empty Cell[/TD]
[TD]formula to pull or equal to Cleaning Supply[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Empty Cell[/TD]
[TD]Office Supply[/TD]
[TD]Empty Cell[/TD]
[TD]Formula to pull or equal to office supply[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Empty Cell[/TD]
[TD]Empty Cell[/TD]
[TD]Guest Supply[/TD]
[TD]Formula to pull or equal to Guest Supply[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1131"]
<colgroup><col span="7"><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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