PDA

View Full Version : Solved: If value in a row = value in another column store in another cell



rajesh nag
05-17-2008, 02:33 AM
HI,

If the values in G2,H2,I2 = value in column C then store that value in K2.
I tried Vlookup, Hlookup its not working for me.

If attached the file for your referance.

Regards,
Rajesh

xld
05-17-2008, 02:49 AM
=IF(G2=C2,G2,IF(H2=C2,H2,IF(I2=C2,I2,"")))

georgiboy
05-17-2008, 11:52 PM
You could try something like this

=IF(COUNTIF(C:C,G2),G2,IF(COUNTIF(C:C,H2),H2,IF(COUNTIF(C:C,I2),I2,"")))

Hope this helps

rajesh nag
05-18-2008, 05:23 AM
:friends: Thanks