INDEX MATCH

 is a lookup formula that can be helpful in locating and pulling data from a list.  



» Excel Functions for Reformatting Data Files (CSV)