Excel Question #46 - Lounge of Tomorrow

02-02-2009, 11:42 AM	#11
Ghoulish Delight I Floop the Pig Join Date: Jan 2005 Location: Alternative Swankstyle Posts: 19,348	My turn. I'm sure this one is blindingly stupid, but I can't for the life of me come up with the solution. Cell A1 has a formula that results in a column letter. Cell A2 has a formula that results in a row number. I want cell A3 to be the value of the cell that would be referenced by the values of A1 and A2. So if the formula in A1 results in "C", and the formula in A2 results in "6", I want A3 to be the value of cell C6. __________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ
	Submit to Quotes

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

All times are GMT -7. The time now is 07:37 PM.