Index Match with resulting rows (in an array?)

[Taipan88]

Hello,

I'm trying to provide the results of an Index-Match (based on only 1 criteria) but provide the details of 1 or more columns. I've tried looking but have only found solutions if I have 2 or more criteria. For instance, my data currently has a column of people names. I have a second schedule (Imm_Previous_Match) that has some of these names with various sets of data for that person, such as their address, date of birth, etc. What I want to do is once I'm able to perform the index-match, (e.g. Jon Smith, etc.) to insert in column 12 and 13 of the row in the current worksheet, provide their Address and Date of Birth from Imm_Previous_Match (this info is located in column K and M)

So far, this currently works but I'm wondering if this will slow or crash the process when I'm dealing with a lot more rows:

Please Login or Register  to view this content.

Any suggestions would be really appreciated!