批踢踢實業坊 ask 板: [請問] EXCEL 對照表格中的值－2016徵求年菜推薦網路訂購最紅的商家.年菜訂購?台北年菜外送餐廳推薦(年菜)?年菜.今年不想做年菜推薦,網路宅配哪一家好?

Blogtrottr

批踢踢實業坊 ask 板

Jul 11th 2013, 21:31, by coollary

作者coollary (黃金本丸)

看板ask

標題[請問] EXCEL 對照表格中的值

時間Thu Jul 11 21:31:49 2013

請教教我如何用兩個條件交叉找出對應值甲乙丙 A 1 2 3 B 4 5 6 C 7 8 9 例如我想找符合 B & 乙的值 (就是表格中的5) 請問我該使用什麼公式？ google都只有欄或列單獨對應沒有這種交叉對應的請線上大神解答感恩 -- 那些以為會看到㊣妹的人要失望囉說了你會失望唄 → ← ￣￣￣￣￣￣￣￣￣￣￣￣￣￣￣￣￣￣ ﹨(╯▽╰)∕ -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 36.231.10.123

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions