Search and Link Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1405525%22%20slang%3D%22en-US%22%3ESearch%20and%20Link%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405525%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Is%20it%20possible%20to%20create%20a%20cell%20that%20can%20be%20used%20as%20a%20search%20function%20that%20once%20a%20value%20is%20place%20into%20it%20will%20link%20and%20move%20you%20to%20another%20sheet%20that%20the%20value%20corresponds%20to.%3C%2FP%3E%3CP%3EEg.%20Search%20for%20%22A002%22%20on%20Sheet%201%2C%20Press%20Enter%2C%20Transferred%20to%20Sheet%20A002.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20Advise.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1405525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406527%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20Link%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F674162%22%20target%3D%22_blank%22%3E%40Maddy1992%3C%2FA%3E%26nbsp%3B%2C%20if%20the%20values%20to%20be%20searched%20are%20few%20%2F%20finite%20%2F%20fixed%20%2C%20then%20you%20may%20want%20to%20create%20a%20list%20of%20all%20possible%20sheet%20names%20and%20hyperlink%20the%20cell%20text%20to%20the%20sheet%20of%20that%20name.%20It%20would%20be%20like%20an%20index%20where%20when%20items%20are%20clicked%2C%20the%20respective%20sheet%20opens..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20cell%20%26gt%3B%20Insert%20%26gt%3B%20Links%20%26gt%3B%20Place%20in%20this%20Document%20%26gt%3B%20Select%20sheet%20%26gt%3B%20OK%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22amit_bhola_0-1589999551993.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193361iCC84BD1A1BBB1DD0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22amit_bhola_0-1589999551993.png%22%20alt%3D%22amit_bhola_0-1589999551993.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, Is it possible to create a cell that can be used as a search function that once a value is place into it will link and move you to another sheet that the value corresponds to.

Eg. Search for "A002" on Sheet 1, Press Enter, Transferred to Sheet A002.

 

Thanks for any Advise. 

1 Reply
Highlighted

@Maddy1992 , if the values to be searched are few / finite / fixed , then you may want to create a list of all possible sheet names and hyperlink the cell text to the sheet of that name. It would be like an index where when items are clicked, the respective sheet opens..

 

Select cell > Insert > Links > Place in this Document > Select sheet > OK

 

amit_bhola_0-1589999551993.png