Can R3 be any other value besides 1,2,3,4 or 5?

Will it ever be empty?

Biff

"lccubb" wrote in message
...
I have the following formula and can not get it to work. Could someone
have
a look please.

Thank you in Advance.


IF(AND(G3="Change"),IF(R3=1,'Data Validation'!C32,IF(R3=2,'Data
Validation'!C33,IF(R3=3,'Data Validation'!C34,IF(R3=4,'Data
Validation'!C35,IF(R3=5,'Data
Validation'!C36,""))))),""),IF(AND(G3="New"),IF(R3 =1,'Data
Validation'!C26,IF(R3=2,'Data Validation'!C27,IF(R3=3,'Data
Validation'!C28,IF(R3=4,'Data Validation'!C29,IF(R3=5,'Data
Validation'!C30,""))))),"")

What I want is that if G3 = the word "Change" then look at another table
and
give me the results if R3 =1, 2, 3, 4, or 5. If G3 = the work "New" then
look at another table and give be the results if R3 =1, 2, 3, 4, or 5.