Excel problem
HiI 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方法,終於互相學習後就大家都搞掂。 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. okok..thx thx 你可以在sheetsA的drink table給個名稱先 , 然後在sheetsB用VLOOKUP , HLOOKUP 或 MATCH 去 attach 出來 .
頁:
[1]