Hi

I am assuming that sheet2 you meant the data is in Columns A to C and not
Rows 1 to 3
On sheet1 in cell B2
=IF($A2="","",INDEX(Sheet2!$A:$C,MATCH($A2,Sheet2! $A:$A,0),MATCH(B$2,Sheet2!$1:$1,0)))

Copy across through cells C2:E2
Copy B2:E2 down as far as required

Better still create a Pivot Table of the data on Sheet2
Insert a Header row at Row1 with Name, Product and Value as the column
Headings
Place cursor in cell A1DataPivot TableFinish
On the PT skeleton that appears on a new sheet,
Drag Name to the Row area
Drag Product to the Column area
Drag Value to the Data area as Sum of Value
The PT instructions are for XL2003. Post back if you want instruction for
XL2007
--
Regards
Roger Govier

"Listu" wrote in message
...
i would like to look up a value from worksheet2 based on cells matching
the
row and column from worksheet1 together...example below

worksheet 1
COLUMM
ROW.. MILK VEGETABLES FRUITS MEATS
salesperson1 ?? ?? ??
??
salesperson2 ?? ?? ??
??
salesperson3 ?? ?? ??
??
salesperson4 ?? ?? ??
??


worksheet2 ( sales report)

ROW 1 ROW2 ROW3
salesperson1 MILK 321
salesperson1 CHOCOLATE 211
salesperson1 MEATS 765
salesperson2 VEGATABLES 90
salesperson2 DONUTS 672
salesperson3 FRUITS 389
salesperson3 SALADS 300
salesperson4 MILK 111
salesperson4 FRUITS 865
--
Listu

__________ Information from ESET Smart Security, version of virus
signature database 4800 (20100123) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4800 (20100123) __________

The message was checked by ESET Smart Security.

http://www.eset.com