# Compare 2 cells in different worksheet and place the value

Closed
sureshtrb Posts 2 Registration date Wednesday November 7, 2012 Status Member Last seen November 12, 2012 - Nov 7, 2012 at 05:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2012 at 11:03 AM
Hello,
I am not expert in excel, and i need help to use a formula to compare 2 cells in other worksheet and fill the value in a blank cell if it is true!

Example:
Sheet1
A1(Blank) B1
A2(Blank) B2
A3(Blank) B3

Sheet2
a1 b1
a2 b2
a3 b3
a4 b4
.....

Need to fill A1 in Sheet1, if (Sheet2) b1 or b2 or b3...(range of cells) are equal to B1 or B2 or B3... in Sheet1, then the same row value in ax to be filled in Ax or else the cell value should be blank

Hope not confusing too much.

Related:

## 2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 8, 2012 at 09:56 AM
Hi Sureshtrb,

Let me see if I get this right:
Compare Sheet1 B1 with Sheet2 B1.
When not equal A1 and AX1 of Sheet1 will be blank.
When equal fill A1 and AX1 of Sheet1 with... Did I miss that part or didn't you mention what to put in A1 and AX1.

Best regards,
Trowa
sureshtrb Posts 2 Registration date Wednesday November 7, 2012 Status Member Last seen November 12, 2012
Nov 12, 2012 at 09:40 AM
Regret for the delay for clarification as i am engaged in a shutdown. busy...
made a simple formula. to solve the issue temporarily;

=IF((F2='CO-RMVL'!A3),'CO-RMVL'!C3,0)

anyway i once again feel sorry for the delayed reply and thanks
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 12, 2012 at 11:03 AM
So it's solved?

To keep cell blank use "" (double quote twice) instead of 0.