[µo°Ý] ¬dªí­pºâ

babesia

sheet1
Á~ÂI «Ý¹J
210  20000
220  21548
230  25874
245  27584
260  25874

sheet2
220  B1

­Y·Q¦bSHEET2ªºB1Àx¦s®æ
­pºâA1Àx¦s®æªºÁ~ÂI(220)»P¨ä§C¤@µ¥¯Å¤§Á~ÂI(210)¤§«Ý¹J®tÃB(¬dSHEET1¤u§@ªí)
¦bB1À³¦p¦ó¤U¤½¦¡©O

ANGELA

=LOOKUP(A1,Sheet1!A2:A6,(Sheet1!B2:B6-Sheet1!B1:B5))

Hsieh

¦^´_ 1# babesia


    210ÂIªº®tÃB­pºâ¼Ð·Ç¬°¦ó?
­Y210ÂI®tÃB¬O20000
Sheet2!B1°}¦C¤½¦¡
=LOOKUP(A1,Sheet1!$A$2:$A$6,Sheet1!$B$2:$B$6-IF(ISNUMBER(Sheet1!$B$1:$B$5),Sheet1!$B$1:$B$5,0))

register313

¦^´_ 3# babesia

³]A2=220
B2=VLOOKUP(A2,Sheet1!A2:B6,2,0)-VLOOKUP(A2-0.1,Sheet1!A2:B6,2,1)
    =VLOOKUP(220,Sheet1!A2:B6,2,0)-VLOOKUP(219.9,Sheet1!A2:B6,2,1)
      §ä220 ¶Ç¦^21548                 §ä219.9(­Y§ä¤£¨ì«h§ä¶È¦¸©ó219.9¤§­È,§Y200) ¶Ç¦^20000

    =21548-20000

babesia

B2=VLOOKUP(A2,Sheet1!A2:B6,2,0)-VLOOKUP(A2-0.1,Sheet1!A2:B6,2,1)

½Ð°Ý¤½¦¡¤¤A2-0.1¬O¥Nªí¤°»ò·N«ä?

register313

¦^´_ 1# babesia

B2=VLOOKUP(A2,Sheet1!A2:B6,2,0)-VLOOKUP(A2-0.1,Sheet1!A2:B6,2,1)
B2=LOOKUP(A2,Sheet1!A2:A6,Sheet1!B2:B6)-LOOKUP(A2-0.1,Sheet1!A2:A6,Sheet1!B2:B6)
B2=INDEX(Sheet1!A2:B6,MATCH(A2,Sheet1!A2:A6,0),2)-INDEX(Sheet1!A2:B6,MATCH(A2,Sheet1!A2:A6,0)-1,2)
B2=OFFSET(Sheet1!A2,MATCH(A2,Sheet1!A2:A6)-1,1)-OFFSET(Sheet1!A2,MATCH(A2,Sheet1!A2:A6)-2,1)