Hi-
I have a spreadsheet that looks at individuals and the amount they paid
within a certain year for healthcare expenditures. Based upon this level of
expenditure, I would like Excel to spit out the Category that the individual
falls into. Here is what the table for looking up the category looks like:
A B C
Category Min Max
00 $0 $20
01 $20 $165

Thus, if the expenditure is $17, they would fall into category 00. How do I
do this in Excel? I know its probably an easy VLOOKUP function but I'm not
sure how to do the VLOOKUP function when telling Excel that it should
determine whether the value falls in between the Minimum and Maximum for the
category. Any help is greatly appreciated!
thanks!