Drag & drop in vlookup function

  • Thread starter Drag & drop function in vlookup
  • Start date
D

Drag & drop function in vlookup

Recently, when I use the drag and drop function in vlookup, it only copies
the top cell instead of posting the correct value from the table array. If I
redo the formula for each cell it will work. Any suggestions???
 
N

Niek Otten

Tools>Options>Calculations tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Recently, when I use the drag and drop function in vlookup, it only copies
| the top cell instead of posting the correct value from the table array. If I
| redo the formula for each cell it will work. Any suggestions???
 
Top