Search value in cells and copy adjacent value to specific cell

Hi, I am a beginner in excel and am trying to search for a Fax number (available in cell C2) from a list of Fax Numbers and their corresponding Names spread across cells H2 to AK2. Once I find the matching fax number I want the corresponding name to be put in a cell(f2). I have uploaded the excel file. Any help would be appreciated. Thanks.

insert this formula in f2 and you can copy it down

Please Login or Register  to view this content.