SOLVED

Formula Help

Brass Contributor

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

2 Replies
best response confirmed by spalmer (Brass Contributor)
Solution

@spalmer 

Try

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

That worked!  thank you very much

1 best response

Accepted Solutions
best response confirmed by spalmer (Brass Contributor)
Solution

@spalmer 

Try

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

View solution in original post