Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Referencing a cell address from another cell 1

Status
Not open for further replies.

SellOut

Technical User
Jul 5, 2004
30
GB
Hello,

I want to show in one cell the value of another cell which is based on a number and a letter in another two cells.

Something like:
=[cellA1][cellB2]

Where cell A1 holds a letter refering to the column and cell B2 holds a number refering to the row.

Thanks for any help!

 
Try
Code:
=INDIRECT(B2 & C2)
Where B2 and C2 are where you have the letter and number stored
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top