Search for matching cell value in multiple columns

Occasional Visitor

I'm having trouble searching a value in multiple columns.

I work with phonenumber mailing lists. Whenever I receive a new list, I must compare to my "database" to remove numbers that already have been used.

It worked using vlookup when my database only had one column of numbers, but when it reached the limit of +- 1 million numbers of the first column, I had to add more columns of numbers and it stopped working considering that now I have 4 columns of numbers and vlookup will only search in the first column.


1 Reply

@MhaxAbreu consider using Power Query. Then the 1 million row limit is no longer in play.