Put this formula in B4 of Sheet1:

=INDEX(Sheet2!$B$2:$D$4,MATCH(B$1,Sheet2!A$2:$A$4, 0),MATCH($A4,Sheet2!$B$1:$D$1,0))

and then copy across and down as required.

Note that the spellings have to be the same to get an exact match - you show
"tech mgr" in the first sheet, but just "tech" in the second sheet in your
example.

Hope this helps.

Pete

"Jonathan Horvath" wrote in
message ...
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