Vlookup Problem

[Red's]

Hi all,

15: 30
16: 23
15: 35
17: 20

In the VlookUp function, if the table_array index is not unique,
as the example above, how can I get the value of "35" ?

Thanks in advance.

Best Rgds,
Rick Lillian

 

[Don Guillett]

to find the largest number in col c that matches 15 (cell b1) in col b, use
this array formula which must be entered/edited with ctrl+shift+enter vs
just enter. smallest =min

=MAX(IF(B3:B9=B1,C3:C9,0))