Thread: searching two columns

Hi Folks,

Is there a good way to check two columns at the same time and return the value in the 3rd?

Example

12 0.07 8
12 0.37 10
12 0.82 12
12 1.30 15
12 3.90 22
12 8.00 28
12 15.00 35

I look for 12 in the first column with vlookup but I need to also look for a figure in the 2nd column which is greater than my figure.

So say I want 12 & 6.0 I would want the formula result to be 28 because the nearest larger number in the table column 2 is 8.00.

Cheers

Martyn

If your table is in A1:C7, try:

=INDEX(C1:C7,MATCH(1,INDEX((A1:A7=12)*(B1:B7>=6),0),0))

replace 12 and 6 with cell references if desired.