Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(AND(C4="",D4="",NOT(E4=""),NOT(F4=""),G4="",H4="",NOT(I4=""),J4=""),index('46'!B:B,match(K4,'46'!A:A,1),1)+((K4-index('46'!A:A,match(K4,'46'!A:A,1),1))/(index('46'!A:A,(match(K4,'46'!A:A,1))+1,1)-index('46'!A:A,match(K4,'46'!A:A,1),1))*(index('46'!B:B,(match(K4,'46'!A:A,1))+1,1)-index('46'!B:B,match(K4,'46'!A:A,1),1))),IF(AND(NOT(C4=""),NOT(D4=""),E4="",F4="",G4="",H4="",I4="",NOT(J4="")),index('35'!B:B,match(K4,'35'!A:A,1),1)+((K4-index('35'!A:A,match(K4,'35'!A:A,1),1))/(index('35'!A:A,(match(K4,'35'!A:A,1))+1,1)-index('35'!A:A,match(K4,'35'!A:A,1),1))*(index('35'!B:B,(match(K4,'35'!A:A,1))+1,1)-index('35'!B:B,match(K4,'35'!A:A,1),1))),IF(AND(C4="",D4="",E4="",F4="",NOT(G4=""),NOT(H4=""),NOT(I4=""),J4=""),index('57'!B:B,match(K4,'57'!A:A,1),1)+((K4-index('57'!A:A,match(K4,'57'!A:A,1),1))/(index('57'!A:A,(match(K4,'57'!A:A,1))+1,1)-index('57'!A:A,match(K4,'57'!A:A,1),1))*(index('57'!B:B,(match(K4,'57'!A:A,1))+1,1)-index('57'!B:B,match(K4,'57'!A:A,1),1))),"ERROR")))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement