Can i do calculations on cell references or something similar?

[Douglas]

I have a spreadsheet that i plan to hide the row and column names.

In my spreasheet starting at cell b7 thru to b16 i have the numbers 1
to 10 (Identifier NUmbers)
and in cells c7 to c16 i have values that can be anything between 1
and 100

elsewhere in the spreadsheet i would like to be able to reference the
values, by the user typing in the Identifier Numbers and then display
the corresponding value
can this be done?

eg

if the user enter the number 5 in cell D20 then value at C11 appears
in E20,
if the user enter the number 8 in cell D21 then value at C14 appears
in E21 etc

the calculation requires 6 to be removed from the row number but im
not sure how to do it?

Can it be done?

TIA

Doug

 

[Otto Moehrbach]

One way:
Put this formula in any cell outside of the range B7:C16. Put any value
from 1 to 10 in F1 and the cell with the formula will show the corresponding
number found in C7:C16. HTH Otto
=VLOOKUP(F1,B7:C16,2)