•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
If K2 equals X1 (pulled from sheet 2) then I2 equals X2 (pulled from sheet 2)
I am trying to create a formula where I have a drop down in column K linked to sheet 2 column 1. I want column I in sheet 1 to auto populate based on the response from dropdown K. To be specific, column K contains GL names (office supplies, miscellaneous, lunches, etc.), and I want all office supplies to be 5200, misc. to be 5300, etc. I keep getting different errors when trying to use XLOOKUP/VLOOKUP/IF.
Thank you so much for your help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#formula generator
#Excel alternatives
#K2
#X1
#I2
#X2
#dropdown
#sheet 2
#column K
#sheet 1
#auto populate
#GL names
#formula