vlookup to another spreadsheet not working

A

Adam

Dear All,

This seems to be a temperimental problem.

When I try and do a vlookup from one file into another, I
do the usual =Vlookup( then select the lookup cell, then
switch into the other spreadsheet to select the range.

Only when I go to select the range it selects them but
not in the formula so I then go to press ,2 and it types
this into the first cell in the selected range.

Anyone know why this is happening, as I said it happens
rarely but I'd like to know why !

Many Thanks,

Adam
 
Top