Array formula query: How to do a mini look up?

Hi,

I'd usually do a vlookup for this but i'm trying to expand my excel know how so I figured i'd attempt an array formula. I'd like a cell to return a number based on the quarter selected in another cell. Cell B3 is a drop down where you can only select Quarters 1-4. How do I create a formula to return the number 3-6 dependant on the quarter selected in B3? I've had a bash and come up with the following which just pastes it into the cell like text.

{=LOOKUP(B3,{Quarter 1,Quarter 2,Quarter 3,Quarter 4},{3,4,5,6})}

Admittedly I don't really know what i'm doing so i'd be grateful if someone could point out where i'm going wrong?

Thanks,

Snook

Hi,

Your formula looks pretty good except that it doesn't need to be CSE enterted and the quarters need to be surrounded by "" because they're strings.

Formula:

Please Login or Register  to view this content.

If B3 is empty then the formula returns #N/A.

If you always want the quarter number +2 perhaps try

=RIGHT(B3)+2