Mick --

Is the data you copied and pasted formatted as text, but you're typing in
numeric values? If you're getting a #N/A returned, that might be a cause.

HTH

"Mick" wrote:

Hi,

I am copying and pasting data from one sheet to another. When the Vlookup
formula is run it does not pick up the copied and pasted cells-but it will
pick the typed text.....Is there a way around this?

Thanks