Thanks for your help, I don't think my explanation was clear enough.

However I found the answer from another post:

=Index(the table of values,match(group input,Group 1-3 column,0),match(numeric input,numeric row,0))