•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
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]
Want to read more?
Check out the full article on the original site
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