Import data from workbooks - advanced!

I have a spread sheet that has the data I want to use in another workbook and I want workbook 1 to look at workbook 2 and pull the corresponding data. for example: if A1 in workbook 1=C1 workbook 2, then populate data in C2 workbook 2 in cell A1 workbook 1, if not look in D1 on workbook 2, if that equals A1 workbook 1, then populate data in D2 workbook 2 in cell A1 workbook 1, if not, then repeat through the following 40 rows. This is the function that i have used to get it to work for about 10 rows... but the formula is too long if I want to have it check all 40 rows:

=IF((E9=""),"",IF((E9=[Book1]Sheet1!$F$2),[Book1]Sheet1!$E$2,IF((E9=[Book1]Sheet1!$F$3),[Book1]Sheet1!$E$3,IF((E9=[Book1]Sheet1!$F$4),[Book1]Sheet1!$E$4,IF(E9=[Book1]Sheet1!$F$5,[Book1]Sheet1!$E$5,"")))))