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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 19
find and add function between sheets 2
sumif or sumproduct with a left statement 5
Count column if heading exists 4
Lookup across multiple columns 3
Index and match across columns 5
***Conditional Formatting Multiple Cells*** 1
IF Statement Problem 4

Back
Top