ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[Âà¶K] VLOOKUP¦p¦ó¤ñ¹ï¨â­Ó¥H¤W±ø¥ó?

[Âà¶K] VLOOKUP¦p¦ó¤ñ¹ï¨â­Ó¥H¤W±ø¥ó?

°ÝÃD»¡©ú:

¤ñ¤è»¡
SHEET 1
¢Ï¢°¦WºÙ¡@ ¢Ð¢°¤Ø¤o ¡@ ¢Ñ¢°ª÷ÃB¡@
CDA(¤@ÂI) 3/8"
¡@¡@
SHEET 2
¢Ï¢°¦WºÙ¡@ ¢Ð¢°¤Ø¤o ¡@ ¢Ñ¢°ª÷ÃB¡@
CDA(¤@ÂI) 1/4" 61,040
CDA(¤@ÂI) 3/8" 69,200
PN2/GN2/O2(¤@ÂI) 1/4" 94,374

¦pªG§Ú§Æ±æ§Q¥ÎSHEET1ªºA1»P B1¨â­Ó±ø¥ó¨Ó¤ñ¹ïSHEET2ªºA1¡B B1¡BC1µM«áÀ°§Ú¥N¥XSHEET1¤¤ªºC1ª÷ÃBÀ³¸Ó«ç»ò°µ©O?



¦b Sheet2 ´¡¤JA Äæ¡A·í¦¨»²§UÄæ
A2 ¿é¤J¤½¦¡ =B2&C2
¦^ Sheet1 ¤u§@ªí C2 Àx¦s®æ¡A¿é¤J¤U¦C¤½¦¡¡G
VLOOKUP(A2&B2,Sheet2!$A$1D$4,4,0)
¦¹¤½¦¡¥i¥H©¹¤U½Æ»s
§¹¦¨

¦^´_ 1# jntseng


    C2=LOOKUP(2,1/((A2=Sheet2!B:B)*(Sheet1!B2=Sheet2!C:C)),Sheet2!D: D) ¤U©Ô
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

C2=VLOOKUP(T(Sheet1!a2&Sheet1!b2),Sheet2!A: D,4,0)

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD