Compare 2 cells in different worksheet and place the value

Closed
Report
Posts
2
Registration date
Wednesday November 7, 2012
Status
Member
Last seen
November 12, 2012
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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.
Waiting for expert advice.

2 replies

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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
Posts
2
Registration date
Wednesday November 7, 2012
Status
Member
Last seen
November 12, 2012

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
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
So it's solved?

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