I have created a drop down listing a number of products. When i select one on these products in the drop down I would like this to automatically input a cost value in another cell.
Please could someone help on how i could perform this task
Many thanks
Take a look at vlookup
http://www.contextures.com/xlFunctions02.html
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks