READ THIS UPDATED POSTING: Problem using fill with formulas

[Gary]

(Previous posting contained an error in the formula.)

I have a column. I want to fill in the formula from B1 all the way
down to B200. I select B1 and drag my mouse down to B200 and select
Fill Down. The formula is inserted in every cell. However, I have:

=VLOOKUP(A4,[yahoo.xls]Sheet1!$A1:$H200,2,FALSE)
=VLOOKUP(A5,[yahoo.xls]Sheet1!$A2:$H201,2,FALSE)

when I want the second instance to be:

=VLOOKUP(A5,[yahoo.xls]Sheet1!$A1:$H200,2,FALSE)

In other words, I want the first cell reference (A) to change, but not
the cell references in the yahoo.xls worksheet. Because they are
changing, I need to go in and manually change the references to
$A1:$H200. I am a newbie, so apologize. This must be a naive question.
Can someone point me to information on this? Also, is there a way to
do a mass search and replace to change all instances of a formula?

Thanks for any help.

 

[Bill Kuunders]

Question 1
=VLOOKUP(A4,[yahoo.xls]Sheet1!$A$1:$H$200,2,FALSE)
note the extra $ signs

Question 2
edit and replace?

Regards
Bill K