title: MATCH() one of multiple values in Excel?
body: <p>I have 100+ sheets of financial data, and i am creating a master sheet, with all the companies data on one comprehensive sheet. I have almost everything, but the problem is companies sometimes list Revenue Per share as many different things (could be Total Sales per share, Total Sales per ADR, Net Operating Revenues per share, etc). </p>
  
  <p>The thing is, since none of these are listed together, each sheet will always have only one of those from the list.</p>
  
  <p>Is there a way to use the MATCH function with a list of values, and if one of them exists in the specified Array, give me that row number?</p>
  
  <p>For example: </p>
  
  <p>lets say sheet1 has the value "Net Operating Revenues per share", and i want to use the match function without looking and having to specify. Instead, i just want to list some values, and if MATCH finds ONE of them, give me that row?</p>