can anyone teach me how can i lookup for 2 separate data from different
table? for example in table A, i use data year '1' and type 'a' to look
for a value in another table who got different year,different type and
value. The main point is to search for the value who is equal to year
1 type a. The other table, table b would have data like year 1 to 5,
type a, has value of 5.5 , year 6 to 10, has value of 7.1
thanks


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