logical function

[jpatil20]

Hello friends,

I have to put formula in excel as follow
if A1 belongs B1 and if A2=A1 then destination cell should display value of B1

is it possible.


thanks in advance.

Jayesh Patil

[NBVC]

What does: if A1 belongs B1 mean?

[jpatil20]

hello .
thanks for your reply
My query is
A1 cell contains (J122) and B1 cell contain (20), now i want to set formula that when I will enter (J122) in any cell of A column the
B column should give (20) automatically.

thanks

[darkyam]

=IF(A2=A$1,B$1,"") in B2, dragged down as necessary.

[jpatil20]

thanks very much

regards-
Jayesh