View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_457_] Simon Lloyd[_457_] is offline
external usenet poster
 
Posts: 1
Default V-Lookup question?

Hi,

Can you supply the code you were using...if you created a dropdown lis
using data validation you will have allowed a list rom anothe
sheet...so you already have a lookup list so if you use the matc
scenario it can match the value in B10 with the lookup list you used i
data validation and you would use this code in the worksheet shee
selection change or if its for the whole workbook on the the workboo
sheet selection change....i think...if i have it right!

Simo

--
Message posted from http://www.ExcelForum.com