Snasui Excel Forum • Category

Page 1 of 1

Category

Posted: Sat Mar 20, 2021 2:41 pm

by sna

Hi Dear

I need your input for a formula to fill column A base on cell value in column B.

I attached an excel template

Re: Category

Posted: Sat Mar 20, 2021 3:58 pm

by norkaz

A3
=IF(B3="","",IF(AND(A2="",B2<>""),B2,A2))

Norkaz

Re: Category

Posted: Sat Mar 20, 2021 4:28 pm

by sna

Thanks.could we use with lookup?

Re: Category

Posted: Sat Mar 20, 2021 4:55 pm

by norkaz

A3
=IF(OR(B2="",B3=""),"",IF(A2="",LOOKUP(CHAR(255),$B$2:B2),A2))

Norkaz

Re: Category

Posted: Sat Mar 20, 2021 8:13 pm

by sna

Thanks