Sorry the title is really vague, it's hard to describe with a limited number of characters.
I have a column (C) which contains a full list of 250 methods. In column D, is each method's corresponding ID value.
Column A, is a shorter list of methods (all of which appear somewhere in column C). For each of the methods in column A, I would like to retrieve the associated ID in column D based on the matching method (or cell value) in column C. Ideally, I would like to store this ID in column B.
[A: Short list of methods] | [B: Method ID] | [C: Full method list ] | [D: Method ID]
sorry the entries in the columns are long. so simple jpg image is not useful at least to me. Unless I can copy the data in my excel sheet I am not able to even try to solve the problem. you can just highlight the first ten rows and hit control+c and in your reply paste it (control+v). then it will be possible.
meanwhile if some body has given a solution it is ok
There is no facility in this newsgroup to post a sheet in the thread. but you can upload the workbook in a third party web page e.g. speedyshare.com.