VLOOKUP with Hyperlink
Posted by Connie on September 24, 2001 11:23 AM
I have a cell where the user picks a brand name (A6) from a drop-down list made with data validation. Another cell, (A7) contains a drop-down list of model numbers. I'd like the user to be able to hyperlink to a text document that pertains to the choices they've made so they can read more about the brand and model they picked.
Currently I have Table1 which has all brand names in column A, all model numbers in column B, and the path for the hyperlink to that particular document in column C.
My formula (this is where I'm stuck) is:
where "3" represents the 3rd column where the hyperlink paths occur. I think I've got the right ingredients, but I know they are mixed up wrong. Can someone help?