Copy formula to multiple cells

[jrtulare185]

Hi guys, I have a vlookup formula that I want to copy from cell b16 to b30. How can I do that without excel adjusting all of the formula.

The formula looks like this: =vlookup(b16,b1:b15,1,false)
I want b16 to change with the cells but "b1:b15" I don't want to change

it should look like this in the worksheet

cell b16 =vlookup(b16,b1:b15,1,false)
cell b17 =vlookup(b17,b1:b15,1,false)
cell b18 =vlookup(b18,b1:b15,1,false)
cell b19 =vlookup(b19,b1:b15,1,false)
cell b20 =vlookup(b20,b1:b15,1,false)
cell b21 =vlookup(b21,b1:b15,1,false)

Thanks for the help

[mewingkitty]

Ah
Welcome to the world of constants.
When dragging a formula, Excel will assume you want to adjust the cells according to which direction you're dragging it... unless you use those happy little $ thingies.

Please Login or Register  to view this content.

This will keep B1:B15 from changing, no matter how much you move it.

Play around with it in a few cells, you'll figure out the advantages to having $ in only one place, sometimes both, and sometimes none.

[jrtulare185]

thank you, that will make my life a lot easier...