Can be made shorter if you don't mind creating a little "helper" range to
determine the column to return.
If you put this in an out-of-the-way area of your sheet, say Y1 to Z5:
Y - Z
0 2
6 3
13 4
21 5
37 6

Then the formula could be:

=IF(I9=34,VLOOKUP(I9,DeductionsAdditions,LOOKUP(B 1,Y1:Z5),0),"")

You could also name that range to say "list", then:
=IF(I9=34,VLOOKUP(I9,DeductionsAdditions,LOOKUP(B 1,list),0),"")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Simon Lloyd"
wrote in message
...

Alex.............it may be long winded but right on the
money........been tearing my hair out with that.....cos' im kinda
stupid really!

Thanks a lot!

Regards,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=541937