try this idea

=VLOOKUP(I9,DeductionsAdditions,if(b121,5,if(b11 3,4)),,0)

--
Don Guillett
SalesAid Software

"Simon Lloyd"
wrote in message
...

Hi all, i am trying to have a Vlookup statement look at a table
depending on the value in B1, IF I9 =34 Then IF the value of B1 is =<5
Look at column 2 ElseIf B1 =6 AND =<12 Then Look at column 3 ElseIf B1
=13 AND =<20 Then Look at column 4 ElseIf B1 =21 AND =<36 Then Look
at column 5, I know what i'm trying to get at but lack the knowledge to
put all the above in to a function in I10, DeductionsAdditions is the
named range i am looking up from.
=VLOOKUP(I9,DeductionsAdditions,6,0)

Can anyone help here?

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