[請問] EXCEL 對照表格中的值:－2014星座運勢大預言, 唐立淇2014星座運勢, 2014星座運勢處女座, 2014星座運勢雙魚座, 2014星座運勢天秤座, 薇薇安2014星座運勢

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