depending on answer, populate 10 other boxes with a yes (Possibly If formulae or index?)

[jassa]

Hi

So i have 15 different job positions in a table.

Now depending on there job position the next 10 columns will be populated with a yes depending on there job position, which assigns if they need to visit site 1 up to site 10. not sure the best way of setting this up?

Should i create a table with this information or can a if statement be used?

Thank you in advance

 

[awoohaw]

jassa, i'm guessing you want 15 rows by 11 columns. not sure why you need any if statments. maybe you could mock up a an example and post it using the xl2bb add in.