Lookup Code to find data in a given range

Hi,

Need help in creating a code to find the data of a given cell within a range of raw data. Here is the code on what I have so far. I tried doing a record macro using copy and paste to find the data but I'm getting the value only when pasting.

Please Login or Register  to view this content.