How do i convert this line into a vlookup?

[jllav]

How could I convert this 'IF' into a VLOOKUP function?

=IF(H20 is inbetween 12-14),1,IF(H20 is inbetween 15-17),2,IF(H20 is inbetween 18-19),3,IF(H20 is inbetween 20-21),4,IF(H20 is inbetween 22-23),5,IF(H20 is inbetween 24-25),6,IF(H20 is inbetween 26-27),7,IF(H20 is inbetween 28-30),8,IF(H20 is inbetween 31-32),9,IF(H20>33),10,"")

I know "is in between" is not part of any excel function, just wanted to spell it out for clarity of what it is I want to do.

Thanks in advance.

[NBVC]

Try:

=LOOKUP(H20,{0,12,15,18,20,22,24,26,28,31,33},{"",1,2,3,4,2,6,7,8,9,10})

[jllav]

Sweeeeet, worked like a charm.