IF Formulas

[mwhit]

Hello:

I am trying to use the if formula to retreive column headings for three different columns. Is it possible to use ONE formula to retreive a specified column name? For example: I have the following info in columns A-C:

Column A
1
Column B
2
Column C
0

I can write the if formula for info in column A but can i write it to look at all three columns???? Or is there a better way ?? Thanks!

 

[barry houdini]

Can you explain a bit more?

Perhaps you need a formula like this

=INDEX(A$1:C$1,MATCH(2,A2:C2,0))

returns the column header from A1:C1 corresponding to the first instance of 2 in A2:C2

 

[mwhit]

Barry,

I am trying to determine the souce of my costs. The column headings are the source names. In column A, i will "Global" in column B i will have "Solomon" and in column C i will have "Master"

When i write the if formula: =if(a2>0,"Global", "No") it tells me if the source is from the "Global" table. However, to caputure all sources (other columns), i have to write one formula and do a sort and write another formula to capture the next source.... I just thought there was a more efficient way?

Does that make more sense?