CODEWITHSUNDEEP
office365
Zakier
Zakier

Reputation: 101

Reference a cell within a cell reference?

Ok, so I'm trying to set up a kind of debug sheet for a project I'm working on.

On the sheet I have a range of values from cells b1 the b20 and in c1 thru c20 I have a cost. These cost are dependant upon the cell above.

In the debug section, I want to be able to input a value, say 18, and have it return in the next cell the cost from C18

If I put in a 16, it'll return c16.

This is of course in the cell right next to where I input my test number.

How would I do this?

Upvotes: 0

Views: 31

Answers (1)

Slai
Slai

Reputation: 22886

Index, Offset, and Indirect are some of the main functions to reference a cell.

Lookup and reference functions (reference)

Upvotes: 1

Related Questions