•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Am I not using XLOOKUP correctly? And absolutes $s
I am basically trying to get column "E" (Billing End) on the "Upload sheet" to populate with the values found in column "C" on the "Data sheet"...ONLY IF the values in Data Sheet (B:B) and Upload Sheet (C:C) match AS WELL AS Data Sheet (D:D) and Upload Sheet (B:B) match. Sorry, I could have organized the columns more alphabetically but I figure you'd get the gist of it and I can play around with the figures.
In Upload sheet E2 and pulling formula down, I would put...
XLOOKUP(1,
('Data sheet'!D$2:D$7=B2)*('Data sheet'!B$2:B$7=C2),
'Data sheet'!C$2:C$7,
""
)
[link] [comments]
Want to read more?
Check out the full article on the original site