Blogtrottr
批踢踢實業坊 ask 板
 
[請問] excel 寫函數找資料
Nov 6th 2014, 12:06, by nn70

作者nn70 (陳柏文)

看板ask

標題[請問] excel 寫函數找資料

時間Thu Nov 6 12:06:27 2014

請問有沒有excel函數的高手 https://drive.google.com/file/d/0B1PlPnR25FK5bDJ5LXZrTVNfemc/view?usp=sharing 想寫一個連動的函數公式但寫不出來 想讓 工作表1 裡面提供 week 跟 team 自動去工作表2 裡面找相對的數字 希望好心人能幫忙看看謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 122.117.32.88 ※ 文章網址: http://www.ptt.cc/bbs/ask/M.1415246791.A.580.html

→ soyoso: 可用函數offset,index或indirect配合match 11/06 12:23

推 extremity: D3輸入=HLOOKUP(C3,工作表1!$B$1:$AE$8,$F$1+1,0) 11/06 12:25

→ extremity: 然後公式往下拉即可 11/06 12:26

推 extremity: 在工作表1的B1~AE8找值是C3那行 第F1+1格 0是完全符合 11/06 12:31

→ nn70: 謝謝！ 11/06 12:32

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.
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
arrow
arrow
    全站熱搜

    gsihop20 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄