# Excel formula w/ multiple references from another workbook

#### neonstorm

##### New Member
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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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

Replies
1
Views
246
Replies
11
Views
2K
Replies
1
Views
352
Replies
2
Views
291
Replies
5
Views
278

1,206,755
Messages
6,074,757
Members
446,084
Latest member
WalmitAal

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back