|
#1
|
|||
|
|||
Help needed with Excel Lookup...
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. |
#2
|
||||
|
||||
Removed by poster
__________________
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 Last edited by Pecoflyer; 11-16-2015 at 12:29 PM. |
#3
|
||||
|
||||
__________________
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 |
#4
|
|||
|
|||
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 |
#5
|
||||
|
||||
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
__________________
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 |
#6
|
|||
|
|||
Still need help.
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. |
#7
|
|||
|
|||
Test
Try this one.
|
#8
|
|||
|
|||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help needed in excel VBA to transfer bookmarks | pat263 | Excel Programming | 7 | 11-11-2014 07:56 AM |
Urgent help needed for 2003 Macro to run in Excel 2007 | fredang | Excel Programming | 1 | 12-27-2013 07:34 PM |
Creating Lookup in Excel | vikash kumar | Excel | 2 | 12-06-2010 06:50 AM |
Excel formula needed. | Rod | Excel | 1 | 08-03-2009 06:55 AM |
Excel to lookup Access Database | PeterP | Excel | 1 | 06-11-2009 12:33 PM |