Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Looking for something light while keeping you safe and comfortable during extended waterside activities?

Shop New Drainmaker Shoe for Men, Women and Kids at Columbia!
From our sponsors
用EXCEL 做複數的模糊資料比對
Mar 25th 2014, 01:31

請問我希望用EXCEL 做複數的模糊資料比對
能用哪種公式可以用SHEET1的A欄 SHEET2的C欄模糊資料比對 從SHEET1 C欄 COPY出SHEET2 D欄 ？
我用VLOCKUP沒辦法做

SHEET1
-------------------------
A欄　　　　　　　B欄 C欄　　　　
牛肉鍋燒意麵　　　X13　　　
陽春麵加滷蛋　　　X45　　　　
蛋包飯　　　　　　X67　　　　　
起司豬排飯　　　　X78　　　　　
法國籃帶豬排　　　X98　　　　　
義大利海鮮墨魚麵 X44
醬油拉麵 X33
QW X88
SD X100

SHEET2
------------------------
C欄 D欄
鍋燒意麵 13
墨魚麵 44
拉麵 33
起司 78
海鮮 44
QW88
SD100
豬排飯 78

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

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

    E-mail轉寄