Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Manage your social media

Best social media tool for image publishing to Facebook and Twitter. Look amazing and delight your followers. Get 40% off when you sign up today.
From our sponsors
VLOOKUP進階用法
Sep 23rd 2013, 02:38

B3=VLOOKUP(B2,'SHEET2'!$A$2:$H$5,2,FALSE)
上列為我原本的函數,但我希望找出B2欄位中前三個字和SHEET2中A2欄位中的前三個相同的(不分大小寫),才秀他的第二欄結果,不知要怎麼修改才對呢?
煩請高手指導!

資料範例如下
B2
ABCDE
BCDEG
123GAR

SHEET2
A2 A3
ABCDE 20
BCDFF 15
123456 40

希望結果如下
B2 B3
ABCDE 20
BCDEG 15
123GAR 40

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 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
    全站熱搜
    創作者介紹
    創作者 sdfgdf2 的頭像
    sdfgdf2

    中文名字日文翻譯, 中文翻譯日文名字, 名字日文翻譯, 日文翻譯名字, 日文翻譯字典發音, 日文翻譯網 漢字,

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

    E-mail轉寄