Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Below is sample data. I need to be able to lookup a company (company A, for
example) for fiscal year 2004 and in another workbook I want July's figure to populate the field in the other workbook. The formula also has to take into account that on this worksheet you see here, I will be inserting and possibly deleting rows at any time. Therefore, the formula needs to be such that if I do that, the cell which is populated in the other workbook is still correct. Thanks for any help. Company FY Jly. Aug. Sep. A FY 2005 $6,502.20 $9,899.43 $28,916.10 A FY 2004 $6,949.45 $4,065.00 $5,285.64 B FY 2005 $8,116.75 $2,195.40 $747.40 B FY 2004 $2,166.40 $3,816.34 $814.34 C FY 2005 $283.00 $195.00 $1,716.40 C FY 2004 $404.20 $2,658.33 $982.40 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Which to use - if, vlookup, match, index, offset, vba? | Excel Discussion (Misc queries) | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Vlookup, index, match? | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |