|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#4
09-09-2024, 10:04 AM
|
||||
|
||||
I am continuing to play with finding a solution and came across 'FILTERING' and 'LOOKUP', so I tried both - in the OTHER REFERENCES (BK730).
For LOOKUP I tried: =LOOKUP(BK731,$G4:$G1133,$C4:$C1133) This worked, but only returned 1 of the 13 instances where this reference (BK731) appears. I need all 13 to populate. For FILTER I tried: =FILTER(G4:G1133,BU731=C4:C1133) This only returned a zero. Still trying... 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Return as many Y as the number of occurrence of values in another column | Marcia | Excel | 2 | 11-27-2020 04:19 PM |
| How to split values from carriage-return from the cell | ganesang | Excel | 3 | 12-02-2019 07:16 AM |
| How to match one list with another and return certain values from corresponding cells in excel | Oluagbe1 | Excel | 10 | 02-11-2019 07:00 PM |
| Formula to check combinations of values in one column to find match from another column | kong1802 | Excel | 1 | 06-15-2018 05:26 AM |
| Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
Windows 11 
Office 2021
Threaded Mode