Combination of Lookup formula or VBA code

[Guna13]

Dear Sir,
I am working on a VBA project. I have source data and master data here. Using the source file and master data, I have used VLOOKUP to get details about the BPC Description Values from Master data sheet...

Source file I have

1. Leger account (format 3000, 4400, 6239, 5699,7937, 8464)
2. Dept Code ( 43, 23, 24, 32, 81, 75 )

Master data file I have

1. Leger account ( format 3000, 4400, 6239, 5699, 7937, 8463 )
2. Dept Code ( 43, 23, 24, 32, 81, 75 )
3. Description

Based on my ledger account start with 3, 4, 7, 8 9, I need to get the BPC Description directly from the master data.

If I start with 5 & 6, I will Combine Ledger accounts with Dept codes, based on the combination, I will get its BPC Description from Master data.

I am looking any excel formula or VBA code.
I would appreciate your advice. Could you please?

 

[DanteAmor]

Explain with complete examples what you have on each sheet, what you want as a result and where you want the result.

NOTE XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.