Assume your data in A1:C8, criteria in D2

In E2: =VLOOKUP($D$2,$A$2:$C$8,COLUMNS($E:F))
copy across to F2



"wburritt" wrote:

Hi: I have a cell A1 that displays a taxable income number. Based on that
number, I'd like A2 and A3 to display a tax rate for FED and NC based on the
following table...

Taxable Income
Fed NC
20,000 0.111 0.060
30,000 0.124 0.063
40,000 0.131 0.065
50,000 0.134 0.066
60,000 0.142 0.066
70,000 0.148 0.067
80,000 0.161 0.067

Do I have to use a bunch of if, thens, or is there an easier way. Thanks!