I have multiple tabs in a spreadsheet that show the same data in different
formats. i would like to create some lookups so that I don't have to maintain
the data manually on each tab

For example.

Tab 1 has a side by side comparison of various products (each column has a
different product with all kinds of data for the product in the rows) - such
as product name, tech manager, sw manager, product manager, electrical
manager, etc...

product name product 1 product 2 product 3
launch date
sw release
tech mgr xxx
sw mgr
product mgr


Tab two is a table of resource assignments per product. column 1 lists the
products, row 1 lists the function (tech manager, sw manager, product
manager, etc). the cells then liks who is assigned to each product and
function.

for example tab two:
tech sw product mgr
product 1 jim john eric
product 2 sue scott jane
product 3 bob deb jack


what i would like to do is create a forumla in the cell in tab one that says
"for the product listed in row 1, find that product on tab 2, then find the
function listed in column 1 for this product and find that function in tab 2,
then put the name of that person into this cell"

any help?

thanks,

Jonathan