Automatically filling the cell

[massimoo]

Hello!

If I have a dropdown menu in A1 which has the following data:
Chair1
Chair2
Chair3
and so on..

How can I create a funtion to B1 which would work so that if there is the text "Chair2" in cell A1 it would automatically give a value 200€ to B1?



Thanks a lot for your help in advance!

[oldchippy]

Hi,

Welcome to the forum, presumably each chair has a different value, if so you could use a vlookup table

http://contextures.com/xlFunctions02.html

[massimoo]

Thanks alot! Got it solved!