Yes,
I do something similar with txt files.
For statistical data...
I use VLOOKUP, HLOOKUP and variable IF statements on different programs.
CHECK THIS OUT!!!:
http://www.rondebruin.nl/id.htm
Download the Excel Function Dictionary
at the very bottom of the page!!!!!



Feature names in COlA
Nominal In col B
USL in Col C
LSL in Col D
Actual value in column E

..=VLOOKUP(STATS!A1,A1:E321,5,TRUE)

From the site:
What Does It Do ?
This function scans down the row headings at the side of a table to find a
specified item.
When the item is found, it then scans across to pick a cell entry.

Syntax
..=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFr om,SortedOrUnsorted)
The ItemToFind is a single item specified by the user.
The RangeToLookIn is the range of data with the row headings at the left
hand side.
The ColumnToPickFrom is how far across the table the function should look to
pick from.
The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes,
FALSE for no.