標題: Excel problem [打印本頁] 作者: 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
