CODEWITHSUNDEEP
excel
Alex
Alex

Reputation: 509

Use cell value to specify another cell location

I am building a dashboard in Excel, and pulling values from an OPC connection, but am struggling using a cell value to specify a location of another cell.

I have 3 sheets,

I want to read the value of LiveData!A1 (which is an integer) add 1 to that number, then use that number on 'Main' to make a specific cell's contents equal Descriptions!B(That Number)

The SAP tool I am using does not allow for vba or the address function.

Upvotes: 0

Views: 221

Answers (2)

Scott Craner
Scott Craner

Reputation: 152595

A non volatile option is to use INDEX():

=INDEX(Descriptions!B:B,LiveData!A1+1)

Upvotes: 3

JNevill
JNevill

Reputation: 50219

This is a job for =Indirect(). Indirect() takes in a cell address as a string, and treats that string as the actual address.

Something like:

 =Indirect("Descriptions!B" & (LiveData!A1 +1))

Which will get the number from LiveData!A1, add one to it, then concatenate that number to the string "Descriptions!B". Indirect() will then go get the value at that cell in Descriptions tab.

Upvotes: 1

Related Questions