automatically lookup & tick

Hi,
on tab 2 of the attached doc. in the yellow highlighted columns, i would like a formula to look in tab 1 & tick when a person uses each business type bearing in mind each person can use more than 1 business type. the formula in the cells @ the min only works if they use 1 bus type.
is this possible??
thanks

Try using COUNTIFS:

In H8:

=IFERROR(IF(COUNTIFS(BUSINESS_SUBMITTED[CLIENT NAME],CLIENT_TRACKING[[#This Row],[CLIENT NAME]],BUSINESS_SUBMITTED[BUSINESS TYPE USED],CLIENT_TRACKING[[#Headers],[BUSINESS PROTECTION]]),"P","O"),"")

copied down.

You will need to copy the column of results and paste to each of the other columns... then change only criteria2 to the respective headers for each column.

Maybe I'm reading this incorrectly, however try this in Sheet "2" H8

=IF(INDEX('1'!$H$9:$L$100,MATCH($A8,'1'!$E$9:$E$100,0),MATCH(H$7,'1'!$H$8:$L$8,0))<>"","P","O")

Drag across to Column L then down

In any case look at your names to see how to make the dropdown in Sheet "1" E9 Dynamic to avoid blanks in the list.

Apologies for reverting to 2003 for the attached, I'm away from my 2007 M/Cs

[EDIT]
If I am correct then better with

=IF(ISNUMBER(MATCH($A8,'1'!$E$9:$E$100,0)),IF(INDEX('1'!$H$9:$L$100,MATCH($A8,'1'!$E$9:$E$100,0),MATCH(H$7,'1'!$H$8:$L$8,0))<>"","P","O"),"")