In need of XLOOKUP help!
Attached is the Sheet VENDOR NAME
I am struggling to write an XLOOKUP formula that will give the desired outcome in Truck Template G2 through G4. The formula will live in column G of the Truck Template tab. I need it to take the Material Code in column A and compare it to Code column (column E on the Materials tab). I need it to find the correct line in the Materials tab and return the vendor name (Materials V1 through X1) with the value of 1 in V2 through X4.
I tried to use =XLOOKUP(A2,Materials!E2:E4,(XLOOKUP(Z1,Materials!V1:X1,Materials!V2:X4)))
Z1 is a reference cell that contains the number 1.
Any help would be greatly appreciated. Please and thank you!
Regards,
David
Bookmarks