Excel formula w/ multiple references from another workbook

[neonstorm]

I need some help with a formula in Excel 2003. I have two Excel workbooks. The first WB is a financial report that I am importing data into. I am importing the store number into E4. I also need the fee % from WB2, since it is not in my export file.
______3__________4___________
E_|Store No__|{imported}______|
F_|Store Fee_|{reference WB2}_|

WB2 is a list of store numbers in column 1 with a percentage for each store in column 2. This data is entered manually and saved for reference.

_______1_______2_______3____
A_|Store No_|_______|___%___|
B_|____1____|_______|___6___|
C_|____7____|_______|___7___|
D_|____30___|_______|___5___|

What I am trying to do is have Excel automatically reference the percentage from WB2 by comparing the imported store number in WB1 E4 with the store number list on WB2. In other words, if I import the data for store 1, I would like WB1 F4 to automatically display 6%.

Here's the formula I'm trying to build on. This formula is in WB1 F4.
=IF(E4=[workbook2.xls]Sheet1!$B$1,[workbook2.xls]Sheet1!$B$3,0)

The problem I'm running into is that WB2 has about 30 entries I need to automatically scan through. I'm not sure how to get this working.

Can anyone help?

Thanks!!!

Ryan

 

[neonstorm]

Cancel...

Cancel, I figured it out.

=IF(E4=[workbook2.xls]Sheet1!$B$1,[workbook2.xls]Sheet1!$B$3,IF(E4=[workbook2.xls]Sheet1!$c$1,[workbook2.xls]Sheet1!$c$3,etc etc etc)

Ryan

*******EDIT*******

Cancel the cancel, it's limiting me at about 15 lines. Crap. Can anyone help me after all?

Thanks!
Ryan