IF FORMULAS
 

Looking for help...... In column A1:A16, I have names. In B1:B16 I will
assign random numbers to those names from 1-16. In another part of the sheet
I have 16 columns lets say D:S, (D) being column 1 and (S) being column 16.
when I assign a number in column B, I want the name to the left to appear
above the appropiate column. EX, If B1 is 16 then the name in A1 will appear
above column S.
I am using Excel 2007 Windows Vista. I find this site to be the place for
answers,everyone is great. Thanks in advance.

IF FORMULAS
 

D1:
=INDEX($A$1:$A$16,MATCH(COLUMN()-3,$B$1:$B$16,0))
Fill to S1.


"JOHN" wrote in message
...
Looking for help...... In column A1:A16, I have names. In B1:B16 I will
assign random numbers to those names from 1-16. In another part of the
sheet
I have 16 columns lets say D:S, (D) being column 1 and (S) being column
16.
when I assign a number in column B, I want the name to the left to appear
above the appropiate column. EX, If B1 is 16 then the name in A1 will
appear
above column S.
I am using Excel 2007 Windows Vista. I find this site to be the place for
answers,everyone is great. Thanks in advance.