Hi All,
I am combining two sheets together. The first sheet is data we complete in our office for pallets we have returned. The Second sheet is confirmation from the pallet controller on how many he recieved. I need to conbine them.
Both sheets use the same reference number. Therefore i have created this equation.
=index('Data Sent Back'!$A$1:$I$5000,match(Owing!$C4,'Data Sent Back'!$E$1:$E$5000,0)1)
This calculation works for the matching figures but the ones that do not match return an N/A. I want the N/A to show as 0 to show that the information has not come from the other company and the pallets are still outstanding.
I hope this all makes sense to you, I am starting to loose it.
I am combining two sheets together. The first sheet is data we complete in our office for pallets we have returned. The Second sheet is confirmation from the pallet controller on how many he recieved. I need to conbine them.
Both sheets use the same reference number. Therefore i have created this equation.
=index('Data Sent Back'!$A$1:$I$5000,match(Owing!$C4,'Data Sent Back'!$E$1:$E$5000,0)1)
This calculation works for the matching figures but the ones that do not match return an N/A. I want the N/A to show as 0 to show that the information has not come from the other company and the pallets are still outstanding.
I hope this all makes sense to you, I am starting to loose it.