MrIDontKnow
New Member
- Joined
- Feb 29, 2024
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Trying to use xlookup to search a 6 digit PO# in column of cells that contain multiple POs separated by commas "," or slashes "/" to bring back an invoice #. Some of the POs may have dashes "-", example 4023454-4. Any suggestions?
INV# | PO#'S |
001 - EMI-10046-22 | 426451 |
EI-14887/22 | 429273 |
20221118 | |
D082922-EXT-A | 419913, 426453 |
D090822-EXT-A | |
6000088306B | 427938 |
D101022-EXT-A | 425895 |
W221219E-S | |
EMI-12136-22 | 430746 |
EI-14892-22 | 430493 |
EMI-12136-22 | 430746 |
D010623-EXT-A | 430749, 431899 |
14897-23 | 432276 |
14897-23 | 432276 |
6000089566 | 431018, 429859 |
W230213E-S | |
W230301E-S | 417063-10-1 |
W230327E-S | |
W230508E-S | |
ET-14917-23 | 437048 |
W230612E-S | 402345-4-4 , 410717-5-1, 413067-4-1 , 416013-5-1, 416884-15-4 , 416886-8-2, 417158-11-2, 417381-6-1 , 423754-4-1, 423818-2-2, 423943-7-1 , 424002-5-1 , 424002-5-4 , 424051-11-3, 424051-11-7 , 424051-11-8, 424525-6-1 , 424525-6-2, 424642-2-3 , 424827-3-1 , 424959-3-1, 424986-5-1, 426625-3-1 , 428267-1-1, 428336-1-1, 428369-3-1 , 428529-1-1, 428533-6-5, 429956-4-1, 430860-1-2, 431933-1-1, 436667-1 |
3920656 | 438997,S230612,438954,439175 |
W230703E-S | 416886-8-2, 419764-10-1, 423943-10-1, 424002-6-3, 424051-13-4 , 424051-13-5, 424051-13-6, 424525-8-2, 424640-6-3, 424642-2-2 , 424827-3-1 , 424986-5-1, 426141-8-1 , 428533-6-5 , 429956-5-1 |
W230710E-S | 423279-6-1, 423943-10-1 , 424051-13-6, 424304-5-1, 424525-8-2, 424827-3-2, 425501-3-1, 426141-8-1, 428096-5-1, 428533-6-5 |
W230717E-S | 399277-12-1, 399358-4-1, 404544-13-2, 404545-7-2, 409939-10-2, 412088-9-2, 420032-2-2, 423938-8-3, 423943-11-3, 424051-14-7, 424956-2-1, 426141-8-1, 428533-8-5 |
PO# | INV# |
419913 | =xlookup(E2, |
426453 | |
431018 | |
429859 | |
402345 | |
410717 | |
413067 | |
416013 | |
416884 | |
416886 | |
417158 | |
417381 | |
423754 | |
423818 | |
423943 | |
424002 | |
424002 | |
424051 | |
424051 | |
424051 | |
424525 | |
424525 | |
424642 | |
424827 | |
424959 | |
424986 | |
426625 | |
428267 | |
428336 | |
428369 | |
428529 | |
428533 | |
429956 | |
430860 | |
431933 | |
436667 |