I'm working on a three sheet workbook. There is 2 columns of numbers I am dealing with on one and two. Column B on sheet one is working number. Column B on sheet 2 is finished number. The column on sheet 3 is the daily input of order of appearance of the working numbers on sheet one.
So on sheet two I have used the simple =Sheet3!A1 then populated the rest. This is how I assign the finished numbers. Now I need sheet one to reconcile. Is there maybe and INDEX MATCH combo I could use in D1 of sheet one, that will put the finish number in sheet one that goes with the working number?
Bookmarks