The exercise is to use
VLOOKUP() functions to return the tax rate based on the annual income and number of people in the household.
So far I've tried inputting:
but the third attribute in
VLOOKUP(), or the
col_index_num needs to be changed in order to return the correct tax rate, but that is manual work and isn't the point of the exercise.
Can anyone help me go through this problem?