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