Hello
I am trying to search in a table by two criteria. Firstly I want to search by the code column in Sheet 1, but only looking at the rows in Sheet 2 that dont have anything under customer name, and I want it to return only the first instance. I cannot find a way to get LOOKUP to search for these, and filter returns multiple. Ideally, I'd also want a way for column E to autopopulate once the order was allocated to a customer, but I fear adding it to multiple cells at a time will create a mess, so any assistance with that would also be apprechiated.
Screenshot 2021-08-05 133150.png
Screenshot 2021-08-05 133322.png
I have attached pictures in case the file uploads incorrectly.
Thank you
Bookmarks