Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Find Data using Index Match and column data next

I have a report that is extracted from an accounting software a sample is in the tab called Act vs Bud. I want to isolate specific data so I am using the Index and match to capture data, the only problem is that I need not only the Month (Actual) but also the Budget column next to the data. As you can see when I tried using the same formula for Budget is basically repeating the first one over and over. What I need is to bring in the Jul 12 data and the value on the next column. Is there a way that I can tell excel to bring in the value of the column next to the Month?
TestII.xlsx
0
joeserrone
Asked:
joeserrone
1 Solution
 
SteveCommented:
use the same formula as with the month, but move the index over 2 columns to the budget position... first one done for you here:

=INDEX('Act vs Bud'!$I$2:$ES$401,MATCH($A9,'Act vs Bud'!$A$2:$A$401,0),MATCH(B$8,'Act vs Bud'!$I$2:$ES$2,0)+2)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now