•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