excel formula

[saianandan]

in excel worksheet,if a 6 of sheet 1 equal to b6 of sheet 2,then the value of b6 of sheet 1 equal to c6 of sheet 2

 

[saianandan]

in excel worksheet,if a 6 of sheet 1 equal to b6 of sheet 2,then the value of b6 of sheet 1 equal to c6 of sheet 2.Please tell me the formula

 

[VoG]

Try in B6, Sheet1

=IF(A6=Sheet2!B6,Sheet2!C6,"")

 

[T. Valko]

in excel worksheet,if a 6 of sheet 1 equal to b6 of sheet 2,then the value of b6 of sheet 1 equal to c6 of sheet 2

enter this formula in Sheet1 B6:

=IF(A6=Sheet2!B6,Sheet2!C6,"")

 

[Aladin Akyurek]

in excel worksheet,if a 6 of sheet 1 equal to b6 of sheet 2,then the value of b6 of sheet 1 equal to c6 of sheet 2

Either...

In C6 on Sheet2 enter:

=IF(Sheet1!A6=Sheet2!B6,Sheet1!B6,"")

Or...

In B6 on Sheet1 enter:

=IF(A6=Sheet2!B6,Sheet2!C6,"")