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

[µo°Ý] LOOKUP²Å¦X¦h±ø¥ó¦^¶Ç­È

[µo°Ý] LOOKUP²Å¦X¦h±ø¥ó¦^¶Ç­È

§Úªí®æ³]©w»Ý²Å¦X¤TºØ±ø¥ó(¤é´Á/¨®¦¸/¶¶§Ç)¦^¶Ç­È(©±¦W)¡A
¨Ï¥ÎLOOKUP"=LOOKUP(2,1/(¶g¤@½Õ¾ã!A:A=A5)/(¶g¤@½Õ¾ã!E:E=D5)/(¶g¤@½Õ¾ã!G:G=A6),¶g¤@½Õ¾ã!G4:G12)"
¦ý¦^¶Ç#N/A

½Ð±Ð¤@¤U¦U¦ì«e½ú¡A§Ú¬O­þ³¡¥÷¥X¿ù¤F?

µ²ªG

1.PNG
2023-1-5 18:25

¸ê®Æ

2.PNG
2023-1-5 18:25
20230105.rar (65.02 KB)

¥»©«³Ì«á¥Ñ 013160 ©ó 2023-1-5 18:51 ½s¿è
§Úªí®æ³]©w»Ý²Å¦X¤TºØ±ø¥ó(¤é´Á/¨®¦¸/¶¶§Ç)¦^¶Ç­È(©±¦W)¡A
¨Ï¥ÎLOOKUP"=LOOKUP(2,1/(¶g¤@½Õ¾ã!A:A=A5)/(¶g ...
013160 µoªí©ó 2023-1-5 18:27



¡i §ó¥¿ ¡j  
"=LOOKUP(2,1/(¶g¤@½Õ¾ã!A:A=A5)/(¶g¤@½Õ¾ã!¢Õ:¢Õ=D5)/(¶g¤@½Õ¾ã!¢Ó:¢Ó=A6),¶g¤@½Õ¾ã!G4:G12)"
"=LOOKUP(1,0/((A5=¶g¤@½Õ¾ã!A:A)*(D5=¶g¤@½Õ¾ã!G:G)*(A6=¶g¤@½Õ¾ã!E:E)),¶g¤@½Õ¾ã!G4:G12)"
¸Õ¤F¨â¤è¦¡µ²ªG³£¬O#N/A

TOP

¦^´_ 2# 013160


    ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«á¾Ç«Øij¦p¤U:
B6=LOOKUP(2,1/(¶g¤@½Õ¾ã!$A$2=$A$5)/("®ÈÀ]"&¶g¤@½Õ¾ã!$G$2=D5)/(¶g¤@½Õ¾ã!$E$4:$E$12=A6),¶g¤@½Õ¾ã!$G$4:$G$12)

°õ¦æµ²ªG:
µ²ªG.jpg
2023-1-6 09:04
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD