In A1 I have the letter A
In D2 I have the number 2
Can I somehow reference in a cell the contents of A1 and D2 to return a formula that will return the contents of A2? (This combines the "A" from A1 and the "2" from D2 to form a reference to A2, and return it's value.)
Tried combining TEXT, and ISNUMBER, etc. but Excel doesn't think like I do.
TIA for any thoughts.
Pete
Bookmarks