Dear All,

Hope Everyone is doing good!!!!

My question is that can we make a user defined formula for referencing (function works exactly opposite to VLookup/Index i.e., VLookup/Index formulas will retrieve the values from one cell to other cell where as referencing formula is to write a value in a cell from another cell) a cell value to another cell and has to make this value static

ex: One of my sheet has 3 dropdown lists, based on which my value of cell below those 3 dropdownlists to write in another sheet cell

Any doubts please let me know.