Mar 21 2022 08:19 AM - edited Mar 21 2022 08:21 AM
Hello!
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.
Mar 21 2022 09:46 AM
@MhaxAbreu consider using Power Query. Then the 1 million row limit is no longer in play.