Vlookup to find Exact Match

[AminShailja]

Hello I am trying to run vlookup on one workbook (dest.xlsm) row A1:A, from another workbook (Source.xlsm) row A1:A

Lets say, and ID( AA101) in Dest file has multiple findings in source file. Now I need only those records which has "Exceeded" in the adjacent row.
Please help me with this.

I have used vlookup through VBA Macros for this. but the result only fetches first row of every ID.

Anyone please can help me sort this out?

 

[AminShailja]

I am affraid I can't upload any file out of company links.
Can you please take the data from the images I have sent?

and I need to use VBA code to run this

 

[AminShailja]

ID	Status
AA101	In Progress
AA102	In Progress
AA103	Exceeded
AA104	In Progress
AA101	Exceeded
AA104	Exceeded
AA102	In Progress
AA105	In Progress

ID	Result Status
AA101	Exceeded
AA102	N/A
AA103	Exceeded
AA104	Exceeded
AA105	N/A

These are two tables

 

[AminShailja]

You will get a list of all of the rows which have that ID and which contain the value Exceeded.
I thought that was what you were trying to achieve.
You don't say what you want to do with this information, but having determined through the VBA filter what that range is, you can then do whatever you wish with that information.

The filter trick does not work. Anything else you can suggest?

 

[Special-K99]

That's better, cant read the images too well.

This looks like it works
=IFERROR(INDEX(Sheet2!A$2:A$1000,AGGREGATE(15,6,ROW(B$1:B$1000)/((Sheet2!B$2:B$1000=VLOOKUP(D$1,A$2:B$1000,2,0))),ROWS(A$2:A2))-(1-1),1),"")