On Sheet1 I have an ID# in Column A, with its value in Column B:
(A--B)
.#--$
.#--$
.#--$
.#--$
On Sheet2 I have the same type of ID#s in Column A, with Names In B:
(A----B)
.#--Name
.#--Name
.#--Name
.#--Name
I have been trying to figure out how to get the matching IDs with their corresponding Name and Value on Sheet3 like so:
(A-----B-----C)
.#--Name--$
.#--Name--$
.#--Name--$
.#--Name--$
Only "twist" to throw in, is i would need some way to see what was left over, Or the Non-matches that were not moved to Sheet3. Reason being, some of the IDs that SHOULD match, may be "different" in the sense that there could be a "#" included or a letter at the end (ex: 01234A)
Any help on this annoying issue would be greatly appreciated, Thanks!
Bookmarks