娛樂滿紛 26FUN's Archiver

hermit 發表於 2004-11-15 12:26 PM

Excel problem

Hi

I m creating an excel which is abt drink record.
In sheetA, i enter a lot of drink name, size, color and prize. (such coke, fanta)
In sheetB, how can the size, color and prize appear automatically when i type in the name?

thx

金魚佬 發表於 2004-11-16 09:26 PM

你要將你個 FILE  ATTACHED  先至得,

我以前係學校學,個亞SIR都識吾哂所有FUNCTIONS,將佢將一個CLASSIC PROG做例,然後每個識小小既人加上佢地每人都有D方法,終於互相學習後就大家都搞掂。

catbert 發表於 2004-11-17 11:32 AM

hermit, you can consider using the VLOOKUP function.  It will be easier if you can attach your file so that we can have a better idea what you really want to implement.

hermit 發表於 2004-11-19 09:53 PM

okok..thx thx

MKL-nananeno 發表於 2005-3-28 05:15 PM

你可以在sheetsA的drink table給個名稱先 , 然後在sheetsB用VLOOKUP , HLOOKUP 或 MATCH 去 attach 出來 .

頁: [1]

Powered by Discuz! Archiver 7.0.0  © 2001-2009 Comsenz Inc.