=HYPERLINK(XLOOKUP($C$2,Recipes!$B$2:$B$101,Recipes!$A$2:$A$101),”Monday’s Breakfast”)
I’m using this formula to reference, then pull a hyperlink from a table on another sheet in excel. The hyperlink is selected from a drop down list at C2. I want the Hyperlinked cell to be blank when Leftovers is select in the drop down at C2.
I’m not sure on how to squeeze an IF formula in or what the best practice would be for this.
jtaylor58182 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.