Forum Discussion

Iron Contributor

Nov 01, 2020

Solved

Formula Help

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, ...

Nov 01, 2020

Try

=IF([@[Vendor Info]]="Yes",HYPERLINK("#'Vendor Info'!A11","Vendor Page"),"")

HansVogelaar

MVP

Nov 01, 2020

spalmer

Try

=IF([@[Vendor Info]]="Yes",HYPERLINK("#'Vendor Info'!A11","Vendor Page"),"")

spalmer

Iron Contributor

Nov 01, 2020

That worked! thank you very much