Combine data from multiple workbooks into one worksheet based on condition

Hi udfxrookie007,

You can use lookup formulas (Vlookup, Index / Offset & Match etc) to achieve the desired result.
Post a sample workbook if you face any challenges. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>