My goal is to solve this equation:
{=INDEX(Sales_Data,MATCH(C3&A5,SalesDataB:B&SalesData!AD:AD,0),41)}
The MATCH function is producing a #NA result.
When I use the formula wizard for just the MATCH function..
{=MATCH(C3&A5,SalesData!B:B&SalesData!AD:AD,0)}
..the wizard shows the formula result (row#) as 3,539. When I go inspect the table, in fact row 3,539 is the right row.
However, when I hit OK, in the wizarditself, it sheet shows the value as #NA.
I don't understand what is wrong with MATCH function. Is it the formatting of the cell?
Help is appreciated.
Bookmarks