•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
Tagged with
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#financial modeling with spreadsheets
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#XLOOKUP
#Upload sheet
#Data sheet