Excel has a vLookup Function which allows you to match a variable to that in a column of data and where there is a match return a value based on the offset you choose in this case lets say the offset is 1 column to the right.
For example: the data you wish to match in a lookup table is "Smith" and the value you want to extract and return is 777777 [a phone number perhaps].
For AutoIT purposes the data would be saved to a *.txt file with each line of data comma delimited.
In Excel the