if formula - Microsoft Community

i need create formula if value entered in cells b9 through b109 corresponding "a" cell equal value in cell b5.......any

ie: if b13 has data entered a13 equals value of b5 (which date)

basically looking automatically enter date listed in b5 cell in column if respective cell in column b has entered

i need create formula if value entered in cells b9 through b109 corresponding "a" cell equal value in cell b5.......any

ie: if b13 has data entered a13 equals value of b5 (which date)

basically looking automatically enter date listed in b5 cell in column if respective cell in column b has entered

try following formula in cell a9:

=if(b9<>"",b$5,"")

set format of cell a9 date.

copy cell a9 down way cell a109.

hope helps /lars-Åke

Office / Excel / Other/unknown / Unknown/other