Forum Discussion
Deleted
Apr 16, 2018Return 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 of those items - and those items will change from time to time. I want to create a column/formula (say column b on Tab 2) that will search Column A on Tab 1 - find matching alphanumeric to Column A on Tab 2 and return the value in Column B on Tab 1. Make sense? Thanks for any help --
Tab 1 Example below
610 93 | 7 |
PM18 | 1 |
MS16EK50 | 3 |
MS15EK | 3 |
PM17 | 1 |
CBL | 1 |
970 772 1 | 1 |
MS!6EK | 1 |
M48JQD | 1 |
310 83 | 2 |
310 8 | 4 |
610 6969 | 7 |
Hi Lance,
If items are unique in tab 1 when INDEX/MATCH will work https://exceljet.net/index-and-match
- Deleted
I will try that - thank you!