I need help trying to come up with a formula that will allow me to input two pieces of data and then update a box with a number. In the picture attached it shows an example of what I need. If I input John & 3, it should return Blue, or Billy & 2 should return Yellow. Any help would be greatly appreciated
You can use the VLOOKUP function to do this.
Let's assume that you have entered the name ("John") in cell A1, the number (3) in cell B1 and the table from the question in the range A2:E6.
The formula looks up the contents of cell A1 ("John") in the first column of the range A2:E6 (where the names are) and returns the contents of the nth column of that row of the table (where n is one more than the contents of cell B1).