Forum Discussion

Deleted's avatar
Deleted
Apr 16, 2018

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 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 937
PM181
MS16EK503
MS15EK3
PM171
CBL1
970 772 11
MS!6EK1
M48JQD1
310 832
310 84
610 69697

Resources