LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 21
Smile INDEX_MATCH or VLOOKUP with multiple criteria?

Hi. I have searched and tried everything I can find about using multiple criteria to return values, but I have not found anything that will work for my project. Basically, I have multiple sheets and each sheet has a unique company number at the top and then rows with dates below it. I need these sheets to look at a a different sheet that has date rows for several company numbers and dollar amounts. Each of the company sheets needs to be able to bring in the correct dollar amount for that company and date. I've attached a workbook to show what I'd like to be able to do. I'd really appreciate any help you could give me.

Thanks!
Attached Files
File Type: zip Multiple criteria INDEX_MATCH or VLOOKUP file.zip (5.8 KB, 115 views)
 
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
Vlookup multiple criteria multiple occurrences sum values se7098 Excel Worksheet Functions 0 March 26th 09 07:31 PM
Vlookup with Multiple criteria and multiple sheets Cinny Excel Worksheet Functions 4 June 21st 07 01:47 AM
Vlookup for multiple criteria, multiple worksheets jtoy Excel Worksheet Functions 4 January 25th 07 09:26 PM
Vlookup for multiple criteria kieffer Excel Worksheet Functions 12 October 5th 06 07:43 PM
Vlookup with multiple criteria Phillycheese5 Excel Worksheet Functions 1 June 28th 05 10:35 PM


All times are GMT +1. The time now is 11:49 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"