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

submitted by /u/South-Result-2672
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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