Ryan,
The function to use is 'vertical lookup' (VLOOKUP). There's info in Excel's help function, if the function wizard isn't clear enough. Or see http://www.ozgrid.com/Excel/excel-vlookup-formula.htm (just the first google hit for excel vlookup, you'll find many more if you go and look for it).
Hope this helps.
Kees
I need some help with a formula. I have two Excel workbooks. The first is a list of store numbers in column 1 with a percentage for each store in column 2. The second sheet is a financial report that I am importing data into. One of the cells I am importing is the store number.
What I am trying to do is have Excel automatically reference the percentage from sheet 1 by comparing the imported store number on sheet 2 with the store number list on sheet 1.
Here's the formula I'm trying to build on. This formula is in workbook 2. Workbook 1 A3 is the store number, workbook1 C3 is the percentage, and workbook2 E4 is the imported store number.
=IF(E4=[workbook1.xls]Sheet1!$A$3,[workbook1.xls]Sheet1!$C$3,0)
The problem I'm running into is that workbook 1 has about 30 entries I need to automatically scan through.
Can anyone help?
Thanks!!!
Ryan

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic