Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-23-2016, 08:00 AM
gebobs gebobs is offline Sync Issues Windows 7 64bit Sync Issues Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Put the concatenated officer's name to the left of the columns you want to look up and the VLOOKUP should work (attached). If that looks like it works, maybe I can dive in further.

I like how you've made good use of named ranges and even the Format as Table functionality, at least for the table on the Officer List tab.
Attached Files
File Type: xlsx attendance2.xlsx (58.8 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sync issues grezmo Outlook 0 06-16-2015 05:12 AM
OneNote and OneDrive Sync issues mchopra OneNote 0 05-22-2015 11:17 AM
Can't sync Outlook calender and contacts to HTC EVO and other issues... Replacement Office 0 03-29-2011 07:22 PM
Outlook 2010 Sync issues 2010Rookie Outlook 0 12-21-2010 08:16 PM
Outlook sync Issues saeed_sp Outlook 0 06-13-2010 10:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft