Hi

Just go to that cell where you contain a farmula like =
vlookup($F4,$f$2:$F$1000,2,0) then press F2 and change the values of range
here.

"Macca1984" wrote:

Hi

If I have input a range of data an example of which is ( 58710; 58729 -
58780; 58789) is it possible for excel to expand the range between 58729
through to 58780 without typing the entire range out by hand?

regards,

Ian