compare 2 cells in different worksheet and place the valueClosed

Question

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.

Configuration: Windows 7 / Internet Explorer 9.0

TrowaD · Answer

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 · Answer

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

Compare 2 cells in different worksheet and place the value

2 responses

Similar discussions

Subscribe To Our Newsletter!