LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Leslie
 
Posts: n/a
Default dynamic, double vlookup, match, index, dget?? different workbooks

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Which to use - if, vlookup, match, index, offset, vba? punsterr Excel Discussion (Misc queries) 3 June 7th 05 07:42 PM
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 3 December 15th 04 01:38 PM
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 0 December 14th 04 11:16 PM
Vlookup, index, match? Phyllis Excel Worksheet Functions 4 December 13th 04 11:23 PM
Vlookup, Index & Match Phyllis Excel Worksheet Functions 1 November 8th 04 06:11 PM


All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"