Lookup/index/match function

[Mparekh]

I have some cells in column A which are blank and would like to use th
existing value in column B. How do I modify the formula. Currently i
just gives me #NA for such cells.

Col A Col B
1 1%
Blank 1.6%
1 2%
blank 2.1%
2 2.2%
2 2.4% and so on

for the cells in col A which are blank, I would like to use th
existing value in Col B, and for col A where there is value I want thi
formula to work and update the corresponding cells. How do I modify th
formula?

Thanks in advance.

Parek

 

[NH]

=IF(A2="",B2,MAX(IF($A$2:$A$8=A2,$B$2:$B$8)))
Again entered as array(ctrl+shift+enter)