Link to item (row) selected in drop down (data validation)

Hi! I've created a workbook with two worksheets. One sheet is a list of customers (each row as a customer record). On the second sheet, I'd like to select the customer from a drop down (which I already have working properly). Then, I'd like to create a hyperlink to that customer row from the result selected in the drop down.

It doesn't appear that there is a way to have the selected drop down item appear as a hyperlink, so I have created a column to the right in which I'd like to just have the word "GO" appear, linking to the selection.

Can someone help, please? I've tried this (from another site) with no luck:

=HYPERLINK("[MGT2012.xls]CUSTOMERS!"&B5,"GO")

workbook name = MGT2012.xls
worksheet name for customers = CUSTOMERS
cell for customer drop down = B5

I'm using Excel 2010.

Thanks so much for any help you can provide.

Try this formula instead:

=HYPERLINK("#CUSTOMERS!R"&MATCH(B5,CUSTOMERS!A:A,0)&"C1","Go")

This assumes that your names are in column A, and will jump to the matching row in the Customers sheet.

Hope this helps.

Pete

YES! You made my day. Thank you!!!

You're welcome - thanks for feeding back. Do you want to mark the thread as Solved ? (The FAQ describes how).

Pete