Formula experts here?

Hi!

I have some trouble finding the right formula for getting this too work as I want it too do. I have a column that has a cell containing a list, and the data from the list K4:K6 and L4:L6 is the price on each product in K4:K6. How to get the price automaticly in E4 after choosen from the drop down list in C4?

Also enclosed a picture!

Thanks a lot to any that tries or comes up with a solution!

Try...

E4, copied down:

=VLOOKUP(C4,$K$4:$L$6,2,0)

Hope this helps!

But thanks anyway! :-)

I've got to get going now, but If you'd like you can email me your file and I'll have a look at it when I get a chance, hopefully, later tonight. If you're interested, you can email me at domenic22@sympatico.ca.

Does it work if you change all , to ;

=VLOOKUP(C4;$K$4:$L$6;2;0)

Ola Sandström