Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill down error for Vlookup
Hi,
I have created a VLOOKUP formula which creates the correct answer for me. However, i need to fill down the formula for the whole spreadsheet (about 38,000 rows) that i am working on. When i do this it moves the lookup table down one row each time i fill. Is there some way that i can copy or fill down the formula without having the lookup table in the formula change with every row? Thanks |
#2
|
|||
|
|||
You can either give that lookup table a nice name.
Select the table Insert|Name|Define Then your =vlookup() will look more like: =vlookup(a1,myTable,2,false) Or you could refer to your table using absolute addresses: =vlookup(a1,sheet2!$a$1:$c$999,2,false) (Notice the extra $'s) Or you could just use the whole column (if there's nothing on the worksheet below that table): =vlookup(a1,sheet2!a:c,2,false) MC wrote: Hi, I have created a VLOOKUP formula which creates the correct answer for me. However, i need to fill down the formula for the whole spreadsheet (about 38,000 rows) that i am working on. When i do this it moves the lookup table down one row each time i fill. Is there some way that i can copy or fill down the formula without having the lookup table in the formula change with every row? Thanks -- Dave Peterson |
#3
|
|||
|
|||
Thanks for your help dave. The suggestion worked.
Much appreciated. "Dave Peterson" wrote: You can either give that lookup table a nice name. Select the table Insert|Name|Define Then your =vlookup() will look more like: =vlookup(a1,myTable,2,false) Or you could refer to your table using absolute addresses: =vlookup(a1,sheet2!$a$1:$c$999,2,false) (Notice the extra $'s) Or you could just use the whole column (if there's nothing on the worksheet below that table): =vlookup(a1,sheet2!a:c,2,false) MC wrote: Hi, I have created a VLOOKUP formula which creates the correct answer for me. However, i need to fill down the formula for the whole spreadsheet (about 38,000 rows) that i am working on. When i do this it moves the lookup table down one row each time i fill. Is there some way that i can copy or fill down the formula without having the lookup table in the formula change with every row? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |