IF FORMULAS

JOHN · External Since: Jan 07, 2007 Posts: 6

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.

Bob Umlas · External Since: Dec 08, 2004 Posts: 51

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

"JOHN" <JOHN RemoveThis @discussions.microsoft.com> wrote in message
news:BD463CF1-9928-4201-A685-9F2613AD6F90@microsoft.com...
> 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.