7 is the max. You haven't really given enough info, but often people
use nested IFs when VLookup would work better, so look in Help for that
function.


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=475068