Help creating a VLookup to retrieve training status

Hello. I need a Vlookup formula which searches one sheet for learners and retrieves data from a specific column. In the attached example, I believe the data to be retrieved is in column 15. I will use this as a template and update the 15 to the correct column number for future reports. Any assistance will be greatly appreciated!

Try this in B2 and copied down.

Formula:

Please Login or Register  to view this content.

Or this:

Formula:

Please Login or Register  to view this content.

BSB

You. Are. AWESOME! Thank you for your help. :-)

No problem at all. Happy to help

BSB

Can you help again please? How should either be adjusted to have it look on the same sheet name in a different workbook? Let's use Example2.xlsx as the second workbook. Thank you!

These should work, but they're dependent on the other workbook being open at the time. If it's closed then you will need a file path in the formulas too. However, if you write the formulas with the other workbook open and when you close it the path will appear automatically.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Hope that helps.

BSB