MS Excel 2003

Let's say I have row 1 containing values 1-31 (so the value in A1 is 1,
B1 is 2, etc all the way until 31). Now in row 2 is where I would put
an "X" in any of the columns that contain a number from 1-31. How can
I create a formula that will give me the value (1-31) from row 1
depending on where I place X in row 2?

TIA


--
martialtiger
------------------------------------------------------------------------
martialtiger's Profile: http://www.excelforum.com/member.php...fo&userid=4743
View this thread: http://www.excelforum.com/showthread...hreadid=483202