Camparing two coloumns in excel and copy another cell value [Closed]

Report
Posts
1
Registration date
Friday January 18, 2013
Status
Member
Last seen
January 18, 2013
-
Posts
1
Registration date
Friday January 18, 2013
Status
Member
Last seen
January 18, 2013
-
Hello Sir

I have two excel files where I want to match file1 Coloum A with File2 Coloumn A If match found File1 Coloumn C cell value should copy to File2 Coloumn C of same row/cell
Kindly help me out please.

Kindly help me out please, I have old files where I have match with new files and copy of the values.

Please......

1 reply

Posts
1
Registration date
Friday January 18, 2013
Status
Member
Last seen
January 18, 2013

Hello SP Kumar,
I try to help you. Try to use formula =if(logical_test;value_if_true;value_if_false)
- Type the formula at coloumn C file-2, =if(
- Click coloumn A file-2, than type =
- Click coloumn A file-1, than type ;
- Click coloumn C file-1, than type ;
- Type 0 or value if false, than type )
- Erase $ sign
- Enter
- Copy the formula to other rows

Good luck.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!