Create quote System

  • Thread starter Thread starter Mr.D
  • Start date Start date
M

Mr.D

I am in the process of trying to create an invoice/quote system i
excel. I was wondering how I create a drop down menu that when
particular value is selected from the drop down, it will return a valu
in another cell for instance, in the menu will be "bag of chips" whe
selected puts the value 1.25 in another cell? I have tried differen
commands, but I am a newbie and I am not quite getting it. Any hel
would be appreciated!!!

Thanks!!!

Mr.
 
Hi Mr. D!

As one method try using VLOOKUP

Your VLOOKUP table will have items in column 1 and prices / values in
column 2.

Your VLOOKUP formula will look at the data validated list and be
something like:

=VLOOKUP(A1,$L$1:$M$20,2,FALSE)

Your data validated list can use the list you create in column 1 of
the VLOOKUP table.
 
Hi

i have a sample order / invoice workbook that does this (& more) email me
direct if you'ld like a copy

Cheers
JulieD
 
Back
Top