What I have is this situation (in its simplest form)
I have an MS Access Database called Device Signals.mdb with a table called
€œDevices€� that contains 3 Fields (Primary Key, Acronym, Description). There
are 160,000 records in the database. Example of a worse case acronym in the
Acronym Field is L30_LST.SWI. The Description Field is simply the text
description of the Acronym. Both fields are formatted as text in MS Access.

In Excel I have a single spreadsheet I call (Sheet 1). Sheet 1 has 2 Rows.
The 2 rows can sometimes be 200 columns wide. Row 1 is Acronyms pasted from
field data, which is never in the same order. Row 2 is a place-holder for the
Descriptions.

What I need is some code (similar to VLOOKUP in Excel) to scan Row 1, got to
the Access database lookup the Acronyms in the €œAcronyms Field€� in Access and
copy the descriptions from the €œDescriptions Field€� into Row 2 of my Excel
Spreadsheet under the correct Acronym.
I have tried numerous versions of code without success, some work on
numbers, others on text, but none thus far have worked on alpha-numeric data
also taking into account spaces.

Can anyone Help

Thanks in advance

Romefucan