Forum Discussion
RaulSG
Mar 01, 2023Brass Contributor
Reference in a formula
Hello community, I need to get the result of a cell (20) using a formula that references a column and a row. I have tried this way: D7 -> 20 D10 -> ="Sales!D"&ROW(7) //Sales is the sheet name a...
- Mar 01, 2023u r missing INDIRECT around your text ref.
ecovonrein
Mar 01, 2023Iron Contributor
u r missing INDIRECT around your text ref.
RaulSG
Mar 01, 2023Brass Contributor
That's right, it's correct!
Thank you so much
Thank you so much