I have two sheets in my workbook. I need to find a way to match the contents of one column to the contents of another column in the second sheet. To say it another way, I need to know if a given value in a cell in Column A is found in a column on another worksheet in the same workbook.
If Column A in Sheet A has 123456, I want to see if Column A in Sheet B also has 123456.
If it does, I'd like to take the contents in column B of the same row (from Sheet B) and copy them to column B in Sheet A (same row). If there is no match, then I'd like Sheet B, column B to say no match for that same row.
My preference is for someone to tell me how to do this using native Excel commands so I can learn from that. If it makes more sense using scripting to accomplish this then I would need specific instructions on how to install/run and where to modify the script to match the columns and sheet names.
I'm using Excel 2010 and my experience with Excel is low but I have done some very minor work with scripts.
If it's necessary I can email the spreadsheet to you but I don't want to post it publicly.
I've attached a handwritten example but it's upside down :)