•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how to hide xlookup if there is nothing to look up
Our take
Hello Everyone! If you've set up a spreadsheet to help manage ingredient costs for recipes, using XLOOKUP can streamline updates. However, an issue arises when you want to hide XLOOKUP results in empty rows. To ensure that only relevant data is printed, consider using a formula that displays results only when there are ingredients entered.
Hello Everyone
I built a file to help my dad with costing for his recipe's. On one sheet i put all his ingredients and their costs. Then a separate sheet for all his recipes. this way when he updates an ingredient cost, it updates all the recipes that uses that ingredient.
Now I used xlookup to get the prices from the ingredients sheet. is there a way to hide the xlookup if there is no ingredient entered in a row? The reason i ask is because if i add the xlookup to lets say 100 rows and he enters lets say 10 ingredients, if he has to print the page, it will print 100 lines and multiple pages instead of 1 or 2 pages
[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]
- Need some assistance easily organizing what is becoming a rather large spreadsheethttps://i.ibb.co/N6kN1bwz/sample.jpg This is an example of a worksheet I am building on Google Sheets. List of recipes I've made and liked in column A, all the ingredients used across them all in row 1 , the amounts of each ingredient that goes into a specific recipe in the cell that corresponds. This is more of a fun project that may be handy for me later, it's not a huge deal if I can't do what I want but it sure would make it easier if I can since this is becoming a pretty big table. What I would like to be able to do is click on a recipe name in column A, and have Excel or Google Sheets hide every cell that does not specify the ingredient needed and the amount needed for that recipe. Is this possible? Ideas how to accomplish this? This submitted by /u/Due-Editor3682 [link] [comments]
Tagged with
#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#row zero#financial modeling with spreadsheets#Excel alternatives#xlookup#ingredients#recipe#costing#cost#update#sheet#print#rows#pages#lookup#ingredients sheet