Referencing

[cannotunderstandexcel]

Hi, I’m not sure what this is called so it’s hard to search for it but what I need help with is..

We have a list of point IDs e.g B1050, B1052, etc. which are devices on a fire alarm system, and we have a list of fire zones and we need to create a sheet which has the point IDs along the top and the list of fire zones along the side and we need to mark/tick which zones are triggered when a point is activated, e.g. if point B1050 goes in to alarm then fire zones 15, 16 and 17 are triggered

I have all the points and I know which zone trigger for each point, but how do I get excel to read my data so I end up with a chart with ticks in the right places?

At the moment we are having to manually cross reference the information and manually enter the marks in the right places

 

[cannotunderstandexcel]

WOW!! works like a charm, thank you so so much Peter!!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.