Formula help needed

[Rien Stuijfzand]

I can't work out the following problem:

Please see attatchment.

[#2]

Rien,

Put this formula in cell C4:

=VLOOKUP(B4,$E$4:$F$9,2,0)

This is all you need!

[#3]

Hello Haytham,

Thanks very much for the help, it got me on the way.

The correct formula for me ( Office Home and Student 2013) was:

=VERT.ZOEKEN(B4;E4:F9;2;ONWAAR)

I have the Dutch version... ;)

Again, thanks very much for putting me on the right track!!!