Hi all,
I can't get the formula to check if a given number is in the column under a given name. If the number is in the column under the name, then it should give something back like True or a symbol like X. If it's not in, the cell should stay empty.
I'm almost certain I need a horizontal lookup for the name, but I just can't find a way to then have a search in the column under the right name to check if the number is in it.
In cell D10 in the example below, I want to know if Andrew has the number 3 in the column under him.
Any help is appreciated.
I can't get the formula to check if a given number is in the column under a given name. If the number is in the column under the name, then it should give something back like True or a symbol like X. If it's not in, the cell should stay empty.
I'm almost certain I need a horizontal lookup for the name, but I just can't find a way to then have a search in the column under the right name to check if the number is in it.
In cell D10 in the example below, I want to know if Andrew has the number 3 in the column under him.
Any help is appreciated.