Formula to return a value from a list

[amandaw]

Hi, I am sure this is very simple, I have spent a lot of time trying to work it out with no luck! I have a table i.e. Levels 1 - 7 in cells C4:C10 with relevant hours in cells d4:d10 i.e. Level 1 = 6, Level 2 = 12, Level 3 = 18, Level 4 = 21, Level 5 = 27, Level 6 = 60, Level 7 = 90 - I then have a seperate table with a drop down list 1-7 and in the next column I want it to return the number of hours i.e. if I choose level 1 in cell c15 I want cell d15 to return 6. The table that I have the Levels and hours in could change i.e. level 1 could change to 12 hours etc.

I hope I have explained myself clearly enough! Thank you in advance for your help!

[Fotis1991]

=index(d4:d10,match(your cell with drop down list,c4:c10,0))

[amandaw]

Thank you so much, very quick and absoutely what I needed :-)

[Fotis1991]

........................