hi,

how i can vlookup the below';

"##gbws-vm111"

but in the other spreadsheet it states it as: "gbws-vm111"

I want the vlookup to ignore the ## .

hows can i do the above.

thank in advance.