How to use extracted value in cell reference?

user_7826511 0
Viewed 18

I am trying to extract information from Cell B5 with the row information of Cell C8.
The result of Cell C11 should be 3

enter image description here

google-sheets-formula google-sheets
1 Answers

Try this INDIRECT formula

=INDIRECT("B"&C8)
user_15277800
Related