•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Xlookup from another page in Google Sheets
Our take
Hello! It sounds like you're navigating the complexities of Google Sheets while trying to streamline your workflow. Using XLOOKUP to reference data from another sheet can be a powerful way to manage multiple conditions for generating part lists. If you’re encountering errors with dropdowns, it may be due to how the data is structured across your sheets. Exploring a more organized layout could enhance clarity and functionality. I’m here to help you find solutions and simplify your spreadsheet experience. Thank you for sharing your example!
Hello, 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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Xlookup with Nested IF - AdviceHi Guys, I'm working on an Excel sheet, and I'm stuck with something that I shouldn't be stuck with!! Basically, I'm creating a Purchase order that I will print/Email to suppliers, I use various suppliers with all slightly different rates for the same product... I've used Xlookup for most of the sheet being the elegant to solve the various requests, but I'm assuming I need an Xlookup with a Nested IF to settle this issue... 2 Tabs are being used: 1st Tab (Price Book)This is used to store product descriptions(horizontally) and there costs from Different suppliers (vertically). 2nd Tab (Purchase Order)This Tab is a print ready form that is simple, However the bit I’m struggling with is the price part. I select the product from a Data Validation List (Price book) which then populates most of the Purchase Order. I then want the price to be pulled through based on the supplier I have selected for that Purchase Order.... Hope this makes sense… submitted by /u/Sweaty_Sprinkles_539 [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]
- Drop down list from discontinuous cells not workingI have to make a bunch of drop downs referencing a seperate sheet that I cant really edit. some of the lists need to reference cells that arent all contiguous. For instance data validation list on =Sheet1!$A$1,Sheet1$C$1, Sheet!$D$1 yields a "You may not use reference operators for data validation critera" But leaving B1 in there works. i.e. =Sheet1!$A$1:Sheet!$D$1 works. Any way around this? submitted by /u/223specialist [link] [comments]
- Return value based on word found in string of text in a cell?I am building a spreadsheet to help budget some expenses and am trying to automate as much as I can. I have a table in Column H with a keyword like "Gas" or "Electric" and then a corresponding category in Column I that groups this into something like "utilities". I have a spreadsheet where I export my bank statement and Column B is the vendor and Column C is the amt. I have Column D trying to group all the expenses based on the helper table in Columns H and I to quick and easy organize all the transactions for a month. I made the formula: =IFERROR(XLOOKUP(B3,ISNUMBER(SEARCH($H$3:$H$35,B2)),I:I),"Uncategorized") to try and get a return and it doesn't work just yet. I feel like I'm close but I'm not as familiar with XLOOKUP as I want and I cant figure out what I could use to make return any easier. Is there a simpler way to get a return like this from a string of text or am I missing something with how the XLOOKUP works? submitted by /u/Pmme10doller_psncard [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#big data management in spreadsheets#financial modeling with spreadsheets#rows.com#real-time data collaboration#google sheets#conversational data analysis#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#AI-native spreadsheets#predictive analytics in spreadsheets#cloud-native spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications