G
Gary
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 column formula to be:
=VLOOKUP(A4,[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.
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 column formula to be:
=VLOOKUP(A4,[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.