I have a table where rows are numbered from 0-50 and the word Mates Rate down the page. Across the top are two column headings Group and Individual. Depending on who is to sign and the number of items required determines the price
Number Required Group Individual
42 25.50 28.50
43 24.50 27.50
44 23.50 26.50
I want to be able to enter an agrument in a cell a number required ie 42, enter who is to sign ie Group whether it be a group or an individual and then have excel look up my table and return the cost
The answer on my example should be 25.50
I do not know how to get excel to look at the two agruments to determine the value
Thanks in advance
Bookmarks