Trying to use a cell value to reference another cell

[FormR]

AV5, AW5, AV6, and AW6 contain U, 3, U, and 27 respectively.

Probably missing something here, but the red highlighted cells do not seem to be referenced by the formula?

and the expected result as you drag the formula to other cells

?

[BradSparks]

Probably missing something here, but the red highlighted cells do not seem to be referenced by the formula?



?

Sorry. Those were irrelevant by this portion of the formula. The whole thing is much longer, but those cells stay stationary, so they are not relevant to this question.

[FormR]

Sorry. Those were irrelevant by this portion of the formula. The whole thing is much longer, but those cells stay stationary, so they are not relevant to this question.

Try to describe in words what you are trying to achieve - for me it's not clear. I won't be back until the morning, but if you can give a good description of your objective I'm sure you will get the help you need.