product sold is in a drop down list in cell Z14
the list is populated from data validation list from the source named "=Equip_DropDown"
the url is formatted like this:
htps://ww.wireless.com/support/deviceTutorials.do?deviceId=
after the = will be a number depending on the device. so i have vlookup formula to say if the device is 1 then the deviceID is 4509, if the device is 2 then the deviceID is 5893, and so on for all 40 or so devices.
does this make sense? and thanks for your time looking at this!