Range of data with a vlookup condition

[Pumpk1n]

I have a tab in a workbook which contains Recoveries. In that tab, Column B may contain values such as "March 2016" or "April 2016" etc..."

I am working in my tab called "June 2016 and I only want to include the values from the Recoveries tab if the values Match. Is there a way to do that? This is the formula I am using and it's not working correctly.

=IFERROR(IF(Recoveries!B14="June 2016",VLOOKUP(B15,Recoveries!$C$2:D100012,2),0),0)

 

[FDibbins]

vlookup will always only ever return the 1st match - then stop looking. You need something a bit more complex to return multiple matches. Assuming your data looks something like this...

	A​	B​	C​	D​	E​	F​	G​
1​	Name	blah1	blah2		aa	blah1	blah2
2​	aa	10​	aa10			10​	aa10
3​	bb	20​	bb20			40​	aa40
4​	cc	30​	cc30			70​	aa70
5​	aa	40​	aa40
6​	bb	50​	bb50
7​	cc	60​	cc60
8​	aa	70​	aa70
9​	bb	80​	bb80
10​	cc	90​	cc90

E1 contains your criteria
F2=IFERROR(INDEX(B:B,SMALL(IF($A$2:$A$10=$E$1,ROW($A$2:$A$10)),ROWS($A$1:A1))),"")
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try to enter the {} manually yourself.
Copy down, then copy across as needed