Hello. Frank Kabel has helped me greatly with the response to the question
below. However, now I'm trying to be able to create a snapshot or convert the
returned data from the vlookup to independent text that is no longer linked
back to the source sheet. Does anyone know how to acheive this? Thanks!!
_______________________________________________________
ORIGINAL ISSUE BELOW: