'Index-match function returns #N/A when number is used as text
I'm using index-match formula for extracting data from a table("DETAIL"). 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
=INDEX(DETAIL,MATCH(B6,BMID,0),MATCH(D5,DATA_R,0))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|