I work at a sound equipment rental shop. Is there anyway that I could set up a spreadsheet where when I enter in a product, that the price automatically appears. I would appreciate any feedback. Thanks.
I work at a sound equipment rental shop. Is there anyway that I could set up a spreadsheet where when I enter in a product, that the price automatically appears. I would appreciate any feedback. Thanks.
Hi,
Set up your table of items and prices and then use something like Vlookup or Index and match
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlFunctio...tml#IndexMatch
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