Index match and (Compare)

hello All

The JLR tab currently works out the differences between columns. That’s works fine

What I need to happen, if a part number doesn’t appear on the Frim tab, I need the JLR tab to return whatever the customer demand tab is.

If you delete A2 in the frim tab, it currently returns no demand, but there is demand within the customer tab.




Paul

In JLR

in F2

=IFERROR(INDEX('Customer Demand '!F$1:F$2438,MATCH(LEFT($A2,11),LEFT('Customer Demand '!$A$1:$A$2438,11),0))-INDEX(Firm!F$1:F$1326,MATCH(LEFT($A2,11),LEFT(Firm!$A$1:$A$1326,11),0)),INDEX('Customer Demand '!F$1:F$2438,MATCH(LEFT($A2,11),LEFT('Customer Demand '!$A$1:$A$2438,11),0)))

Hello John

that works great, BUT

Any idea how i get rid of the #N/A, and still work in the same manner, Ideally needs to say "No Demand"

Try

=IFERROR(INDEX('Customer Demand '!F$1:F$2438,MATCH(LEFT($A2,11),LEFT('Customer Demand '!$A$1:$A$2438,11),0))-INDEX(Firm!F$1:F$1326,MATCH(LEFT($A2,11),LEFT(Firm!$A$1:$A$1326,11),0)),IFERROR(INDEX('Customer Demand '!F$1:F$2438,MATCH(LEFT($A2,11),LEFT('Customer Demand '!$A$1:$A$2438,11),0)),""))