|
|
#19
07-14-2022, 11:40 AM
|
||||
|
||||
Try this in cell G6, copied down. It may need to be array-entered in Excel 2010.
Code:
=INDEX('Sheet 2'!$D$1:$D$1000,SMALL(IF((('Sheet 2'!$B$3:$B$14=$F6)*('Sheet 2'!$C$3:$C$14=$M$4))=1,ROW('Sheet 2'!$B$3:$B$14)),COUNTIF(F$6:F6,F6)))
Once it's working as you want, you can wrap it in an IFERROR function to hide errors. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul | aligahk06 | Excel | 2 | 09-07-2019 02:23 PM |
| Data Compare and result as true or false in result sheet | aligahk06 | Excel | 1 | 08-29-2019 06:44 AM |
 One Cell that controlls spread sheet result button to change simple fomula result
|
RAH | Excel Programming | 5 | 03-31-2018 04:52 PM |
| Outlook 2013 Gmail IMPA emails not showing dates only showing times | zillah | Outlook | 0 | 12-21-2017 01:20 AM |
| email there but not showing in inbox, notifications showing | bbxrider | Outlook | 0 | 05-15-2017 11:46 PM |
Windows 10 
Office 2019
Threaded Mode