search multiple columns
 

using this formula to find values in column H

=ISNUMBER(MATCH(D2,'[sheet2]Data list'!H:H,0))

my question is if instead of searching just column H i wanted to search
columns A through column BK how do i do that?

search multiple columns
 

Check your other thread for another suggestion.

jason2444 wrote:

using this formula to find values in column H

=ISNUMBER(MATCH(D2,'[sheet2]Data list'!H:H,0))

my question is if instead of searching just column H i wanted to search
columns A through column BK how do i do that?

--

Dave Peterson