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