Pivot table setup with name in row field, week number in column value. Need
to lookup/match the week number then the name and return a 1 value from the
pivot table.

Is this possible?
example:

1 2
3
Sales 1000.00
3000.00
Cost of Sales 350.00 1000.00 200.00
Accounting fees 50.00 10.00 30.00
Advertising 20.00 30.00
15.00
Salaries 40.00
5.00