search multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 
Back
Top