Hi all
I have two workbooks one with detailed data (Bought-out-part orders) and one with shortened data (BOP Orders).
In workbook BOP Orders, column A, I have our order numbers and I need the formula to look into Bought-out-part orders column A.
Match our order number and pull in the required data from (Bought-out-part orders).
Problem is some orders have multiple items on the same order, I can get it to work until I have multiple rows with the same order number but different item numbers. The formula returns the first row's details correct but then any duplicate items it returns the first line again?
Any idea how I can over come this?
=XLOOKUP($A3,'[Bought-Out-Part Orders.xlsx]Live'!$A$2:$A$336,'[Bought-Out-Part Orders.xlsx]Live'!$D$2:$D$336,0)
Hope this makes sense to you?
Thanks in advance.
Pete
PS: I am running office 365 but some in my team are running Office 2019.
I have two workbooks one with detailed data (Bought-out-part orders) and one with shortened data (BOP Orders).
In workbook BOP Orders, column A, I have our order numbers and I need the formula to look into Bought-out-part orders column A.
Match our order number and pull in the required data from (Bought-out-part orders).
Problem is some orders have multiple items on the same order, I can get it to work until I have multiple rows with the same order number but different item numbers. The formula returns the first row's details correct but then any duplicate items it returns the first line again?
Any idea how I can over come this?
=XLOOKUP($A3,'[Bought-Out-Part Orders.xlsx]Live'!$A$2:$A$336,'[Bought-Out-Part Orders.xlsx]Live'!$D$2:$D$336,0)
Hope this makes sense to you?
Thanks in advance.
Pete
PS: I am running office 365 but some in my team are running Office 2019.