Solved

# Find Data using Index Match and column data next

Posted on 2013-01-10
351 Views
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
Question by:joeserrone
1 Comment

LVL 24

Accepted Solution

Steve earned 500 total points
ID: 38764624
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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…