May 13 2022 07:37 AM
I have a cell, B23, that is the reference cell involved in many formulas (a blank cell waiting for an input value to be placed in it and it produces an answer in cell B38). I have several cells in other sheets that I want to place into cell B23 to retrieve answers (i.e. if B23 = O39, what will B38 produce? if B23 = O40, what will B38 produce? etc. etc.).
Is there a way I can do this using a formula or some kind of technique? Any assistance would be greatly appreciated! Thanks!
--
Steven
May 13 2022 07:55 AM
You can use a data table for this. See: