I am trying to match similar numbers between two different worksheets. Ideally I would like to place an "x" to show what sheet has that part.
I have attached a sample of what I am trying to do. Column "a" has a list of part numbers that appear on both sheet 2 and 3, ( marked 9a-12 and 9av-12). Cell B3 and C3 have the titles of sheets 2 and 3 respectively. I know how to use vlookup to place that number where it is used, as shown in cell b4, but I would like to leave an "x" in those cells instead. Can anyone give any hints on how to accomplish this.