VLOOKUP and AutoFill

[Sparkie]

I have a VLOOKUP formula and I am trying to use AutoFill to copy it down the
spreadsheet. If I look in each cell it looks like it copied the formula
correctly as it changes the cell numbers for the new rows but it does not
bring in the correct information, it enters a copy of what is in the original
cell. Any suggestions?
Sparkie

 

[Niek Otten]

You may have to set Tools>Options>Calculation tab, to Automatic.

Are you sure you want the addresses of the Lookup Table to change as well?
If not, change A1 to $A$1 etc


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a VLOOKUP formula and I am trying to use AutoFill to copy it down the
| spreadsheet. If I look in each cell it looks like it copied the formula
| correctly as it changes the cell numbers for the new rows but it does not
| bring in the correct information, it enters a copy of what is in the original
| cell. Any suggestions?
| Sparkie

 

[Mike H]

Your formula would be helpful

 

[Gaurav]

Can you please paste the formula here? It will be easier to understand the
problem.

 

[akphidelt]

It would be much easier to help you if you showed the formula you were using.
But are you adding $ signs around the table_array? Do you have the findings
set to FALSE?

 

[Sparkie]

Niek,
Thank you so much. Changing the calculation to automatic is exactly what I
needed to do.