Getting complete control over your files at any time is important to ease your everyday tasks and increase your efficiency. Achieve any goal with DocHub tools for document management and hassle-free PDF file editing. Gain access, adjust and save and integrate your workflows with other safe cloud storage services.
DocHub offers you lossless editing, the chance to work with any formatting, and securely eSign papers without the need of looking for a third-party eSignature alternative. Obtain the most of your file management solutions in one place. Try out all DocHub functions today with your free of charge account.
welcome to excel metric 937 if you want to download this workbook click on the link below the video in this workbook we want to be able to select a website from a drop-down and have the link automatically update so Im going to come over to this sheet right here I have my table these are the friendly names I want and these are the websites Im going to come up here Im going to do data validation to get a drop-down list alt DL tab I dont want any value I want to list so Im going to select list tab and then Im going to highlight just the friendly names from the first column of the table this will allow only those values in the cell and it will have a drop-down Im going to click OK so now I can select this now I need to look up in this cell at MLB find it and retrieve the internet access from this table here using vlookup but Im going to do it inside the hyperlink function so hyperlink hyperlink you put a link location and a friendly name were going to instead of type in the link