search multiple columns

J

jason2444

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?
 
D

Dave Peterson

Check your other thread for another suggestion.
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?
Click to expand...
 
Top