Thread: Excel Question #46
View Single Post
Old 02-02-2009, 11:42 AM   #27
Ghoulish Delight
I Floop the Pig
 
Ghoulish Delight's Avatar
 
Join Date: Jan 2005
Location: Alternative Swankstyle
Posts: 19,348
Ghoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of coolGhoulish Delight is the epitome of cool
Send a message via AIM to Ghoulish Delight Send a message via Yahoo to Ghoulish Delight
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
Ghoulish Delight is offline   Submit to Quotes Reply With Quote