Suppose I have a table like below, and a reference at c8=a1
How can I get e8 to display 20, so it can be reused based on the content of a5?
e8=[some formula] (c8)
now e8 displays “20” (the content of b1)
It might be XY problem, but I think if I can extract the row number of “a1” from c8, I can use it in indirect(“B”&[row from c8=1])