Forum Discussion

spalmer's avatar
spalmer
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, ...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Nov 01, 2020

    spalmer 

    Try

    =IF([@[Vendor Info]]="Yes",HYPERLINK("#'Vendor Info'!A11","Vendor Page"),"")
HansVogelaar's avatar
HansVogelaar
MVP
Nov 01, 2020

spalmer 

Try

=IF([@[Vendor Info]]="Yes",HYPERLINK("#'Vendor Info'!A11","Vendor Page"),"")
  • spalmer's avatar
    spalmer
    Iron Contributor
    Nov 01, 2020

    That worked!  thank you very much

Resources