Hello,

I was wondering if someone could help me with the following.

I have 2 spreadsheets in a workbook. From the table in sheet1, I would like to lookup everyone that's enrolled in the workshop "7 Habits S1" and have their Last name, First name and Office enter in sheet2.



Thank you.

Attached Files

Test.xlsx (10.5 KB, 9 views)

Removed by poster

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Cross-posted without links at excelguru.ca

Please read this to understand why this is important

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for your reply but the formula didn't work. It's showing as invalid.

Here's a link to the file with the formula you provided.

https://onedrive.live.com/redir?resi...nt=file%2cxlsx

Please post on the forum. External links are potentially unsafe. Be aware that no answers will be provided as long as you have not added links to cross posts

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for your help but the formula you provided didn't work. I changed the semi-colon to a comma but it didn't work.

I've attached the file again with the formula your provided earlier.

Thank you.

Attached Files

Test.xlsx (11.2 KB, 10 views)

Try this one.

Attached Files

Pfiggy.xlsx (11.7 KB, 11 views)

Instead of Sheet1!$D$6 in the IF-part of the formula you can of course refer to another cell, for instance Sheet1!E1 and then enter the criteria (7 Habits S1 or something else) in this cell. After editing remember to hold down Ctrl and Shift before pressing Enter.