•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)
Our take
To create an automated solution for populating values in column I based on the dropdown selections in column K, you can utilize the XLOOKUP function effectively. Your goal is to match GL names from column K with corresponding values from sheet 2. By setting up a dropdown list in column K linked to sheet 2, you can enhance your spreadsheet's functionality. If you encounter errors with XLOOKUP, VLOOKUP, or IF functions, it may be due to syntax or range issues.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Xlookup from another page in Google SheetsHello, I'm a novice user and trying to make a spreadsheet to help with work, using multiple conditions from an order to generate a list of needed parts. I'm getting an error when attempting to reference data from a drop down on another page. I've attached a trimmed down example that I can share without posting work info. https://docs.google.com/spreadsheets/d/1UT6k7b7Sqi0mV6L867CS_jSVQXN15ZyDkHa3gPlTgrg/edit?usp=sharing The real document has more of basically variable, but I think part of the complexity problem is the part numbers I'm trying to generate use the inputs in different ways and in different orders for each part, so I'm trying to make a page for each kind of part data and keep a cleaner UI page. There's probably a cleaner way to do this, that may or may not work with all the actual inputs I need to do, but I'll take any and all advice, I'm just a novice at best. Thank you. submitted by /u/Zestyclose_Silver352 [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
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