Thread: search multiple columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jason2444 jason2444 is offline
external usenet poster
  
Posts: 30
Default 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?
Reply With QuoteReply With Quote