Import lines from Access table.

Hi , I'd like to be able to automatically populate 2 adjacent cells with information depending on what I enter into a 3rd cell.

Specifically , I would like a description and retail price to be returned depending on what part number I enter. The .mdb table I want to access has 3 columns and 252,140 rows .

I tried this with a VLOOKUP across multiple worksheets (tpasted from the access table) but the file was extremely large , it would be more efficient to pulll info as required no?

Sorry if this a n00b question

Thanks in advance.