Excel problem

hermit

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

金魚佬

你要將你個 FILE  ATTACHED  先至得，

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

catbert

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

okok..thx thx

MKL-nananeno

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