need help with if functions. is there a way around about restriction of 7 if functions in one function? i have 9 if situations and now i run out of options is there maybe a vba solution? problem is quite easy...if a=1 vlookup that range, if=2 vlookup another range (to simplify). and that up to 7 times. thanks in advance...