I need to know how to cascade a IF formula down that will only change the
first value of the Logical Test and will leave the true and false statements
unchanged. Example in the formula =IF(B2 = "080012",H2, H3) I need B2 to
update as I cascade (copy) down the spreadsheet but I need H2, H3 to remain
unchanged. I am not able to find anything on the website to handle this. Even
when I copy and paste it updates all three values and not just the one. Can
anyone please help me update the function so that only the Logical Test value
changes.

--
Andrew Holzman