|
|
#8
12-02-2018, 09:56 PM
|
|||
|
|||
Hello All,
I was showing a work colleague the formula from the Ozgrid post (in my second attachment) and he found out I had made a mistake. The formula in columns D to G on the BARRIER_RCS worksheet should have been: Code:
=IF(SUMPRODUCT((CURR_LANE_WIDTHS!$A$2:$A$1015=$B2)*($C2>=CURR_LANE_WIDTHS!$B$2:$B$1015)*($C2<=CURR_LANE_WIDTHS!$C$2:$C$1015),ROW(CURR_LANE_WIDTHS!$D$2:$D$1015))=0,"",INDIRECT("CURR_LANE_WIDTHS!D"&SUMPRODUCT((CURR_LANE_WIDTHS!$A$2:$A$1015=$B2)*($C2>=CURR_LANE_WIDTHS!$B$2:$B$1015)*($C2<=CURR_LANE_WIDTHS!$C$2:$C$1015),ROW(CURR_LANE_WIDTHS!$D$2:$D$1015))))
Just thought I would post this followup as it is another alternative that is not an array formula. Regards, Dave T 
|
|
|
Similar Threads
|
||||
| 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 |
 How can I retreive multiple records using a lookup?
|
jrpey | Excel | 3 | 11-14-2011 02:10 PM |
Windows 7 64bit 
Office 2013
Threaded Mode