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!
|