erm..what i really mean is..from first worksheet, where all the datas
are key in into a table. and on the other hand, the second worksheet
is where i need to get the data from the first worksheet by using 2
data to get one value from worksheet, table one.

For example, worksheet 1,table one contains infos about numbers of
number of stocks by years and blocks. at worksheet 2, when i keyed in
year 1, block 2, i wan to know what is the value/number of stock by
getting the data from worksheet 1, table 1.

my main question is how and what function can i use to get the value.
im trying vlookup function but the function can only compare one data
like year 1 to get one value and not year + block == value.

Hope u all get what i mean.


--
ecwj85
------------------------------------------------------------------------
ecwj85's Profile: http://www.excelforum.com/member.php...o&userid=37703
View this thread: http://www.excelforum.com/showthread...hreadid=572973