Linking My Quoted Rates to Job Screening File

[cychua]

Dear All
I am not sure whether should have use VLOOKUP or macro. I got no idea whether i should google search for more details about macro or vlookup.

I had uploaded 2 excel files.

1st file, named as "quotation" - I put it in a folder. So i can create numerous quotation with different rates for different clients.

2nd File, named as "Job Screening" - i worked as a sales person. I would like to link my quoted rates from the file "quotation" to file "Job Screening" whenever a customer name is keyed in.

Is this possible? I need this to be sorted for my account convenience and easier for my life in recording.
Hope the expertise would give some advise or tips for me, i will do the research and DIY again.

Thanks & B.Regards,
C.Y.Chua