Hi guys

I was hoping someone could offer me some help please, basically I have data in column A and some data in column B and C (data in column B and C are togather). I need help with VLookup which will look for each value in column A and IF it matches anything in column B (from cell B1 to B2000) then i want to display it in E.

Not only this but I want the data from column C (which is linked to the data in column B) i want to display in column F.

So basically after running the Vlookup I want to see which data matches from column a and column b and I want to display this in column e.

if you need any more help or want me to explain anything else then let me know. thanks guys

**Edit is this possible to do in VBA? If VBA is an easier method then I dont mind as I can get the answer.