Forum Discussion
Excel: How Do I Sort Data in One Tab Without Changing the Linked Data in Another Tab?
I have a 'master tab' where I will be entering data into cells in a TABLE. I have subordinate tabs. The subordinate tabs have formulas that populate cells with a mirror of the data that is in the m...
Thank you Sergei. I have not used that function before. Can you refer me to some simple instructions for its use?
- Ben
Hi Ben,
INDEX/MATCH is combination of two functions and together they are some equivalent of VLOOKUP(). In brief MATCH returns the position of the lookup value in the lookup range and INDEX returns the value of the cell on that position. In more details
https://exceljet.net/index-and-match
https://corporatefinanceinstitute.com/resources/excel/study/index-match-formula-excel/
and in many other places.
Attached is the small sample of how it works, both if you use tables with structured references and if you use ranges.