Home

hyperlink with filter

%3CLINGO-SUB%20id%3D%22lingo-sub-523007%22%20slang%3D%22en-US%22%3Ehyperlink%20with%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-523007%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHI%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20one%20more%20question.%20i%20added%20new%20column%20and%20give%20a%20condition%20by%20IF%20formula%20to%20get%20complete%20items%20and%20non%20complete%20items.%20and%20also%20i%20have%20added%20new%20sheet%20and%20copy%20closing%20stock%20details%20for%20it.%20i%20need%20to%20make%20a%20hyperlink%20when%20click%20on%20condition%20column%20cell%20to%20filter%20relevant%20data%20from%20sheet%202%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-523007%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-523745%22%20slang%3D%22en-US%22%3ERe%3A%20hyperlink%20with%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-523745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329467%22%20target%3D%22_blank%22%3E%40Ravindu94%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Sheet1!F4%20of%20the%20attached%20file%2C%20the%20formula%2C%20copied%20down%20rows%2C%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(COUNTIF(Sheet2!A%3AA%2CC4)%2CHYPERLINK(%22%23Sheet2!D%22%26amp%3B%3CBR%20%2F%3EMATCH(C4%2CSheet2!A%3AA%2C0)%2C%3CBR%20%2F%3EIF(D4%3DE4%2C%22Complete%22%2C%22Incomplete%22))%2C%22None%22)%3C%2FP%3E%3CP%3ENote%20that%20the%20foregoing%20formula%20returns%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%22None%22%20if%20the%20item%20is%20not%20found%20in%20Sheet2%3B%26nbsp%3B%3C%2FP%3E%3CP%3EHyperlink%20named%20%22Complete%22%2C%20if%20the%20stock%20is%20sufficient%3B%20or%26nbsp%3B%3C%2FP%3E%3CP%3EHyperlink%20named%20%22Incomplete%22%2C%20if%20the%20stock%20is%20insufficient.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20fulfills%20your%20requirement.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533112%22%20slang%3D%22en-US%22%3ERe%3A%20hyperlink%20with%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533112%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20man.%20its%20nice%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533122%22%20slang%3D%22en-US%22%3ERe%3A%20hyperlink%20with%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533122%22%20slang%3D%22en-US%22%3EYou're%20welcome.%3C%2FLINGO-BODY%3E
Highlighted
Ravindu94
Contributor

 

HI

@Twifoo 

i have one more question. i added new column and give a condition by IF formula to get complete items and non complete items. and also i have added new sheet and copy closing stock details for it. i need to make a hyperlink when click on condition column cell to filter relevant data from sheet 2

3 Replies

@Ravindu94 

In Sheet1!F4 of the attached file, the formula, copied down rows, is: 

=IF(COUNTIF(Sheet2!A:A,C4),HYPERLINK("#Sheet2!D"&
MATCH(C4,Sheet2!A:A,0),
IF(D4=E4,"Complete","Incomplete")),"None")

Note that the foregoing formula returns: 

"None" if the item is not found in Sheet2; 

Hyperlink named "Complete", if the stock is sufficient; or 

Hyperlink named "Incomplete", if the stock is insufficient. 

I hope this fulfills your requirement. 

@Twifoo 

 

thank you man. its nice

You're welcome.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies