Nested IF statement troubles - can't get the final value to appear

Hi,

I'm really struggling to get a formula working and I've been searching for ages without finding an answer!

Essentially I have a column of values, and each one will correspond to either a value in column C, D or E. I want a formula that says if the cell matches a value in column C print "H1", if it matches column D print "H2" or if it matches column E print "H3".

Can someone work out why the 'false' value of the nested IF statement won't work on this formula?
=IF(G4=C:C,"H1",IF(MATCH(G4,D:D,0),"H2","H3"))

Many thanks!!!!

Andy

Maybe,

=IF(COUNTIF(C:C,G4)>0,"H1",IF(COUNTIF(D:D,G4)>0,"H2",IF(COUNTIF(E:E,G4)>0,"H3","")))

This should also do the trick:

Please Login or Register  to view this content.

Thanks so much - can't believe how quick you all helped out! Cheers - problem is now solved. I didn't even think of using countif, and the isnumber function was obviously where I was going wrong.

@oeldere - thanks for the tip, I will do that moving forward