![]() |
#6
|
||||
|
||||
![]()
my apologies, it was one row out.
Code:
=INDEX(CURR_LANE_WIDTHS!D$2:D$1015,MIN(IF(((CURR_LANE_WIDTHS!$A$2:$A$1015=$B2)*(CURR_LANE_WIDTHS!$B$2:$B$1015<=$C2)*(CURR_LANE_WIDTHS!$C$2:$C$1015>=$C2))>0,ROW(CURR_LANE_WIDTHS!$A$2:$A$1015)))-1) Where there are errors, you can IFERROR those out. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple sheet lookup | kevexcel | Excel | 0 | 06-27-2018 12:51 AM |
Sum and Lookup multiple values | coolkat | Excel | 1 | 11-06-2017 03:47 AM |
Match multiple lookup values? | tinfanide | Excel | 3 | 07-02-2017 05:35 AM |
Formula help please (lookup across multiple sheets) | froggybsb03 | Excel | 2 | 03-16-2017 02:16 AM |
![]() |
jrpey | Excel | 3 | 11-14-2011 02:10 PM |