Search row and return column header

[j_alexander]

Hey,

I am trying generate a formula to search a row and when a figure is found, return the column header relating to that row. There should only be one entry per row which I've tried to illustrate below: (Note the total column is being analysed out like a cashbook idea so might allow a match formula?)

	A	B	C	D	E
1		Total	Header 1	Header 2	Header 3
2	**Need Formula to Return "Header 1" **	£15	£15	0	0
3	**Need Formula to Return "Header 2" **	£20	0	£20	0
4	**Need Formula to Return "Header 3" **	£30	0	0	£30

I dont really know where to start with the formula, so any tips are welcome!!!

Thanks!

[ChemistB]

If your data is numbers

=LOOKUP(9E300,C3:E3,$C$2:$E$2)
if text
=LOOKUP("zzzz",C3:E3,$C$2:$E$2)
Does that work for you?

[j_alexander]

Yeh that works a treat - thanks!!