I have two Excel sheets populated with data. I'm trying to take the Part Number and Next Higher Part Number in Columns A and B of Sheet 1 and look for the same Part Number and Next Higher Part Number in Columns A and F of Sheet 2. If a match is found, then I want it to pull over data from Sheet 2 to Sheet 1 (e.g. pull the data in Column B in Sheet 2 to Column M in Sheet 1).
Kind of like a two variable Vlookup...
I can't get photos to post here, but here are links to examples of the two sheets.
https://photos.app.goo.gl/MCfwGXeSvfrJjzYS8
https://photos.app.goo.gl/1B37ZFwTyNzk3M6N9
Kind of like a two variable Vlookup...
https://photos.app.goo.gl/MCfwGXeSvfrJjzYS8
https://photos.app.goo.gl/1B37ZFwTyNzk3M6N9