Okay. Thank you.
here is my code as it stands:
=IF(A4='Source Data'!$A$4,'Source Data'!$B$4,IF(A4='Source Data'!$A$5,'Source Data'!$B$5,IF(A4='Source Data'!$A$6,'Source Data'!$B$6,IF(A4='Source Data'!$A$7,'Source Data'!$B$7,IF(A4='Source Data'!$A$8,'Source Data'!$B$8,IF(A4='Source Data'!$A$9,'Source Data'!$B$9,IF(A4='Source Data'!$A$10,'Source Data'!$B$10,IF(A4='Source Data'!$A$11,'Source Data'!$B$11,"Not Recognized"))))))))
Are you saying that if i used a bunch of IF statements connected by AND then I could use as many IFs as I want?
Jason