1 min readfrom 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!

submitted by /u/batmandi
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article