Nov 01 2020 01:18 PM
I need help with a formula. in the excel sheet attached you will see 2 sheets. 1 labeled Maintenance and the other Vendor Info. I have a formula in H5 that isnt working. What im trying to do is, when I find a vendor to help fix or repair items i want to be able to select Yes or No in Column G if i have or need to write down vendor info. if i select Yes i want my hyperlink to show up like it does and then select that hyperlink to take me the Vendor Page but it isnt working and im getting a reference isnt valid error. If anyone could help me with this that would be greatly appreciated.
Thank You
Nov 01 2020 01:43 PM
SolutionNov 01 2020 01:43 PM
SolutionTry
=IF([@[Vendor Info]]="Yes",HYPERLINK("#'Vendor Info'!A11","Vendor Page"),"")