Sheet 1:
| PO NUM | Comments |
| ——– | ——– |
| 51773 | |
| 51775 | |
| 51777 | |
Sheet 2:
| PO NUM | Comments |
| ——– | ——– |
| 51777 | xyz |
| 63814 | abc |
| 51773 | ghi |
| 63814 | def |
| 51775 | jkl |
I am having trouble getting the PO Number to search and match between the sheets and then apply the comment from the matching PO num to sheet 1. Please Help!!
I have tried VLOOKUP, XLOOKUP, INDEX and MATCH but it is not searching the PO Number from the next sheet even though the numbers match.
Gabi Vidakovich is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.