Collington
Board Regular
- Joined
- Jun 6, 2005
- Messages
- 56
- Office Version
- 2016
- Platform
- Windows
Sorry - no idea how to explain this, let alone do it! Think it's an index/match combo but just can't get it to work...
Anyway what I'm trying to do:
On sheet 1 we enter all of the entrants names and some other details in A-D, then in cells E-Z you can type in what classes they're entering. (One class per cell)
Then on sheet 2 it has the entrants' name and then columns D-CG are all the different classes numbered 1-81. I would like each class to show "0" if they've not entered that class and anything else (whatever's easiest) if they did enter that class. (So that I can then put on a conditional formatting and grey out any boxes with a "0" in it.)
So it will pull through the entrants name from sheet one, but I can't figure out how to get it to take that entrant's name, go back to the first sheet and find that name, then read the row to see if the matching class number appears to then mark it accordingly.
Here's a picture if it helps you at all. https://drive.google.com/file/d/1WsSUBakb9K-46crrhg7mhJWUs_4c1TNH/view?usp=sharing
Thanks so much, I've been wracking my brain but no light bulbs yet!
-A very grateful Lisa
Anyway what I'm trying to do:
On sheet 1 we enter all of the entrants names and some other details in A-D, then in cells E-Z you can type in what classes they're entering. (One class per cell)
Then on sheet 2 it has the entrants' name and then columns D-CG are all the different classes numbered 1-81. I would like each class to show "0" if they've not entered that class and anything else (whatever's easiest) if they did enter that class. (So that I can then put on a conditional formatting and grey out any boxes with a "0" in it.)
So it will pull through the entrants name from sheet one, but I can't figure out how to get it to take that entrant's name, go back to the first sheet and find that name, then read the row to see if the matching class number appears to then mark it accordingly.
Here's a picture if it helps you at all. https://drive.google.com/file/d/1WsSUBakb9K-46crrhg7mhJWUs_4c1TNH/view?usp=sharing
Thanks so much, I've been wracking my brain but no light bulbs yet!
-A very grateful Lisa