I am trying to write a multiple lookup or index function that will operate as illustrated below.
I need a function that looks for an exact match of "Breakfast" in the first columns of the table and finds the row that corresponds to closest to but not greater than "74" in the third column. So that the function returns the appropriate value (in this case "3") from the 4th column.
Much thanks in advance for the help!
Trevor
I need a function that looks for an exact match of "Breakfast" in the first columns of the table and finds the row that corresponds to closest to but not greater than "74" in the third column. So that the function returns the appropriate value (in this case "3") from the 4th column.
Much thanks in advance for the help!
Trevor