SOLVED

Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1842731%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1842731%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20a%20formula.%26nbsp%3B%20in%20the%20excel%20sheet%20attached%20you%20will%20see%202%20sheets.%26nbsp%3B%201%20labeled%20Maintenance%20and%20the%20other%20Vendor%20Info.%26nbsp%3B%20I%20have%20a%20formula%20in%20H5%20that%20isnt%20working.%26nbsp%3B%20What%20im%20trying%20to%20do%20is%2C%20when%20I%20find%20a%20vendor%20to%20help%20fix%20or%20repair%20items%20i%20want%20to%20be%20able%20to%20select%20Yes%20or%20No%20in%20Column%20G%20if%20i%20have%20or%20need%20to%20write%20down%20vendor%20info.%26nbsp%3B%20if%20i%20select%20Yes%20i%20want%20my%20hyperlink%20to%20show%20up%20like%20it%20does%20and%20then%20select%20that%20hyperlink%20to%20take%20me%20the%20Vendor%20Page%20but%20it%20isnt%20working%20and%20im%20getting%20a%20reference%20isnt%20valid%20error.%26nbsp%3B%20If%20anyone%20could%20help%20me%20with%20this%20that%20would%20be%20greatly%20appreciated.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1842731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1843022%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843022%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F289214%22%20target%3D%22_blank%22%3E%40spalmer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(%5B%40%5BVendor%20Info%5D%5D%3D%22Yes%22%2CHYPERLINK(%22%23'Vendor%20Info'!A11%22%2C%22Vendor%20Page%22)%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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 (Contributor)
Solution

@spalmer 

Try

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

That worked!  thank you very much