Hi Patricia,

Have you got my email? I have made the change in the function. VLOOKUP
was not needed here.

I used

=IF(OR(B3='Sites Targeted'!A$3:A$15),"Targeted",IF(OR(B3='Sites
Supplied'!A$3:A$9),"Supplied","None"))


Enter it as array function.

Thanks

shail