Please check the formulae you are given more carefully
=INDEX('bill qty'!D2:D831,MATCH(B16&C16,'Receipted qty'!$A$2:$A$831&'Receipted qty'!$C$2:$C$831,0))=INDEX(Sheet2!$D$1:$D$6, MATCH(A1&C1, Sheet2!$B$1:$B$6 & Sheet2!$C$1:$C$6,0))
Please check the formulae you are given more carefully
=INDEX('bill qty'!D2:D831,MATCH(B16&C16,'Receipted qty'!$A$2:$A$831&'Receipted qty'!$C$2:$C$831,0))=INDEX(Sheet2!$D$1:$D$6, MATCH(A1&C1, Sheet2!$B$1:$B$6 & Sheet2!$C$1:$C$6,0))
Huge thanks for pointing that out
Ok so now it's brought back several answes, though unfortunatley i don't recognise the figures its supplying
In one example it should have brought back an answer of 266.17, instead it's given a result of 1.41
Can anyone help me with what's happened here?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks