興趣嗜好

跳至

首頁
1

尾頁
   0


珍珠宮

積分: 35188

2024年龍年勳章 虎到金來勳章


1#
發表於 06-1-10 17:03 |只看該作者

Help: Excel Vlook Up Funtion

Does anyone can teach me how to use “Vlook up function” in Excel to count exact data in different worksheet?

Normally I need to count Employee who completed the training class or not? In that case how to map both data in one worksheet?

For example: “Sheet One” has Employee no., hire date & “Sheet Two” covered Employee no. & competition status

Thanks.


水晶宮

積分: 57682

2025中秋節勳章 父親節2025勳章 2024年龍年勳章 睛靈勳章


2#
發表於 06-1-10 18:30 |只看該作者

Re: Help: Excel Vlook Up Funtion


Search Here


珍珠宮

積分: 35188

2024年龍年勳章 虎到金來勳章


3#
發表於 06-1-11 10:09 |只看該作者

Re: Help: Excel Vlook Up Funtion

Anka,

Thanks for your advise but that site need to pay by Visa, do you have any free web can search such information?

Thanks


水晶宮

積分: 57682

2025中秋節勳章 父親節2025勳章 2024年龍年勳章 睛靈勳章


4#
發表於 06-1-11 21:50 |只看該作者

Re: Help: Excel Vlook Up Funtion


Click and Search Here

kaheiboy 寫道:
Anka,

Thanks for your advise but that site need to pay by Visa, do you have any free web can search such information?

Thanks


子爵府

積分: 14914


5#
發表於 06-1-12 01:26 |只看該作者

Re: Help: Excel Vlook Up Funtion

我覺得你呢個case 唔一定要用vlookup, 簡單d 用lookup 已經ok喇.

我用lookup整左個sample 出黎, 睇下你合唔合用?

不過記住, sheet1 及 sheet 2 既資料, employee no. 一定要順序(即是要先做sorting), sheet 3的答案才會正確.

反而sheet 3 唔一定要順序, 希望幫到你

SAMPLE ( Click here)


珍珠宮

積分: 35188

2024年龍年勳章 虎到金來勳章


6#
發表於 06-1-12 09:55 |只看該作者

Re: Help: Excel Vlook Up Funtion

Hi OKLA,

Thanks a lot that's great help for me


子爵府

積分: 14914


7#
發表於 06-1-12 10:11 |只看該作者

Re: Help: Excel Vlook Up Funtion

用得著就好喇, 唔駛客氣

kaheiboy 寫道:
Hi OKLA,

Thanks a lot that's great help for me

首頁
1

尾頁

跳至
Presslogic Logo
Baby Kingdom Logo