I'm trying to figure out how to look up multiple different lines based off of a single value. So I've attached a copy of my main data. I'm trying pull the JO# into a different sheet based off the Current Status. So "In-Process Cell #1" has 3 JO#s and I want to pull all of those into a list in a different sheet, where In-Process Cell #2 and #3 only have one JO which I have no problem pulling, but Cell #1 I only get one JO to pull. This is the formula I'm using to find 1 JO so far
=INDEX(owssvr!A:A, MATCH(Sheet2!E1, owssvr!G:G,0))
. Idk if I need an IF or IFERROR or COUNTIF, like if equals Cell E3, which is the first and only JO that I'm pulling, count the next value that matches Cell #1? Any help is greatly appreciated!JO# | SO# | Expedite | Dock Date | Kanban Order | Current Status | Requested | Production Due | Ship Date | Part Number | QTY |
TS-005027-A | KANBAN | FALSE | 12/25/2026 | TRUE | In-Process Cell #1 | 12/25/2026 | 3/20/2021 | 12/25/2026 | MK-029 | 5 |
TS-004441-C | 1005605 | TRUE | 4/5/2021 | FALSE | In-Process Cell #1 | 4/5/2021 | 3/30/2021 | 4/2/2021 | TS-242 | 10 |
TS-004837-B | 1006124 | TRUE | 12/25/2026 | FALSE | In-Process Cell #1 | 12/25/2026 | 3/31/2021 | 12/25/2026 | TS-211 | 9 |
MM-003403-A | 1004180 | TRUE | 12/25/2026 | FALSE | In-Process Cell #2 | 12/25/2026 | 4/5/2021 | 12/25/2026 | AA-110 | 20 |
TS-004860-21 | KANBAN | TRUE | 12/25/2026 | TRUE | In-Process Cell #3 | 12/25/2026 | 4/23/2021 | 12/25/2026 | TS-294 | 28 |