Hi,

Can you elaborate your question? Make it in tabular form.

You might use it this way, if I understood it correctly till now....

=sumproduct((sheet1!A1:A10="data year 1")*(sheet2!A1:A10="Type
a")*(B1:C10))

something like this

But do elaborate your question again.


Thanks,

Shail


ecwj85 wrote:
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