=Hyperlink(vLookup

[bpolkusm]

I have a tab labeled BP Process on this tab I have a list in column A of Friendly names of hyprlinks to documents in a SharePoint List. In column B I have the full web address to that document. See image 1
On tab CV-1 in Cell D9 I have a dropdown list of the file names in column A on the BP Process Tab see image 2
I Cell D10 I am trying to put a link to the document to click on. I have the following formula. =HYPERLINK(VLOOKUP('CV-1'!D9,'CV-1'!A1:H116,2,FALSE),'CV-1'!D9)
see image 3.
When I do this I get returned N/A see image 4

I am requesting assistance on what I need to change in the formula of D10 in order to pull a clickable hyperlink based what business process is chosen in D9

 

[Kerryx]

If links are on a different sheet you need to identify sheet in the lookup

Book1
	C	D
9	BP Name	test3
10	BP Link	www.ryanair.com
CV-1

Cell Formulas
Range	Formula
D10	D10	=HYPERLINK(VLOOKUP(D9,'BP Processes'!A2:B4,2,FALSE),VLOOKUP(D9,'BP Processes'!A2:B4,2,FALSE))

Cells with Data Validation
Cell	Allow	Criteria
D9	List	='BP Processes'!$A$2:$A$4

Book1
	A	B
1	Name	link
2	test1	www.google.com
3	test2	www.delta.com
4	test3	www.ryanair.com
BP Processes

 

[bpolkusm]

If links are on a different sheet you need to identify sheet in the lookup

Book1
	C	D
9	BP Name	test3
10	BP Link	www.ryanair.com
CV-1

Cell Formulas
Range	Formula
D10	D10	=HYPERLINK(VLOOKUP(D9,'BP Processes'!A2:B4,2,FALSE),VLOOKUP(D9,'BP Processes'!A2:B4,2,FALSE))

Cells with Data Validation
Cell	Allow	Criteria
D9	List	='BP Processes'!$A$2:$A$4

Book1
	A	B
1	Name	link
2	test1	www.google.com
3	test2	www.delta.com
4	test3	www.ryanair.com
BP Processes

Thanks so much. That help out greatly.