Forum Discussion
Return a value from different tab based on formula
I have data in Tab 1 that has Alpha Numeric in Column A and a number in Column B. Lets say there are 500 rows of data. On Tab 2 i have same alphanumeric info in column A but far less. Say only 20 ...
Hi Lance,
If items are unique in tab 1 when INDEX/MATCH will work https://exceljet.net/index-and-match
I will try that - thank you!