如何使用vlookup把顏色帶過來:－2016徵求年菜推薦網路訂購最紅的商家.年菜訂購?台北年菜外送餐廳推薦(年菜)?年菜.今年不想做年菜推薦,網路宅配哪一家好?

Blogtrottr

Mobile01最新文章

Own the Game.

Elevate your game with the newest adidas men's soccer footwear and apparel.

From our sponsors

如何使用vlookup把顏色帶過來

Oct 13th 2013, 15:23

請求大大

想請問大大用vlookup 公式要如何將參照的文件的顏色帶過來
範例如下
=IF(A1="","", IF(ISERROR(TRIM(VLOOKUP(A1,Sheet2!$A$15017,2,0))),TRIM(VLOOKUP(A1,Sheet2!$A$1:$Z$15017,2,0))))

而這公式是對應a工作表的A欄位去找B工作表的A欄位去帶出B工作表的B欄位到A工作表
不知道是否有辦法將B工作表的顏色帶過去A工作表嗎??
是不是要使用vba呢?? 因為GOOGLE 始終看不太懂??? 感恩

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:

Massacres That Matter - Part 1 - 'Responsibility To Protect' In Egypt, Libya And Syria
Massacres That Matter - Part 2 - The Media Response On Egypt, Libya And Syria
National demonstration: No attack on Syria - Saturday 31 August, 12 noon, Temple Place, London, UK

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