title: Index-match function returns #N/A when number is used as text
body: <p>I'm using index-match formula for extracting data from a table(&quot;DETAIL&quot;). The formula works well when cell B6 contains number in General/Number format but returns to #N/A when cell B6 contains number in text format. I cant convert it as number because it may be started from zero (0) which disappears when number is used as general format. My formula is</p>
  <pre><code>=INDEX(DETAIL,MATCH(B6,BMID,0),MATCH(D5,DATA_R,0))
  </code></pre>
  <p><a href="https://i.stack.imgur.com/0b1EK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0b1EK.png" alt="Highlighted cell (B6) contains number as number" /></a></p>