I looked at that function, but it will return the location of a
matching item in another column. But what I need is a resulting 2
columns, one with each entry found in any column and the columns that
number exists in. I need to resolve an issue so that every number will
eventually be in every column, which means that the problem I resolve
will result in a pulled list from 3 different systems and they all
match. Thanks.

RB Smissaert wrote:
Look at the Match function in the help.

RBS