IF function with cell reference array formula?

Apologies Dwexdwex, maybe you could try something a little left-field:

Formula:

=INDIRECT("B"&COUNTIF($A$1:$A$5,A3))

P.S. I'm not at my computer at the moment, but I think this formula should do what you want. If it doesn't work then I must have missed a parameter in the function, so let me know and I'll try again when I'm next at my computer.

This will need to be entered as an array formula, not a regular formula.

Hope this helps