I am just wondering if anyone in this forum could help me with my issue.
On a weekly basis, I receive a report from a supplier ("Report" tab), where they state the delivery dates and various PO numbers in Column E.
I then use delimited option to separate each PO individually ("Report (2)" tab).
I have a different report from our internal system with the same PO numbers for which I need to find out the delivery date using the report received from supplier.
Is it possible to lookup a value which potentially could be in any column between E & Y, but still return the result located in column Z.
Until now I have been doing multiple VLOOKUP's, but it's rather time consuming so I was hoping that maybe there is an advanced VLOOKUP formula which can find out what I need in one go.
Any other suggestions would also be much appreciated.