Excel問題

vlookup 是一個解決方法. 請參考下面的 tutorial:


How to Use VLOOKUP Function | Excel VLOOKUP tutorial
Tutorial on how to use Excel's VLOOKUP function for pulling in data from another worksheet. ... Home 5 Minute Tips General Learning VLOOKUP in Excel ... ( Includes Excel VLOOKUP tutorial file) ...www.timeatlas.com/mos/5_Minute_Tips/General/Learni...

VLOOKUP - Excel - Microsoft Office Online
... in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a ... In these cases, VLOOKUP may give an incorrect or unexpected value. ...office.microsoft.com/en-us/excel/HP052093351033.as...

Lookup/Vlookup
不過你之前要做少少嘢先