INDEX MATCH
5 Topics
Index Match Error
Hello, In a tab marked "MRP" I have parts list. In that tab, I'm trying to fill the "Description" column (C) by pulling the value from another tab labeled "PRICING", column E. I'm using this formula: =INDEX(PRICING!$A$1:$H$427,MATCH(A2,PRICING!$A$1:$H$427,0),5) So ... it should index the entire pricing tab, find "A2", which is a part number listed in the "MRP" tab, and return the value in the 5th column of that row. Instead, I get a #NA error. What am I missing here? Thank you for your help!Solved1.4KViews1like2Comments