Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-14-2011, 12:31 PM
cpladson cpladson is offline Using IF and Vlookup functions Windows XP Using IF and Vlookup functions Office 2007
Novice
Using IF and Vlookup functions
 
Join Date: Dec 2011
Posts: 2
cpladson is on a distinguished road
Default Using IF and Vlookup functions


I'm not sure if IF and Vlookup is the right combination here. I'm working with 2 sheets. 1 Sheet is a long list of account numbers in one column, and their ID # in another column. Tab 2 just has a long list of account numbers. What formula can I use on tab 2 to search tab 1, match the account numbers and then populate the approriate ID #? Any help is appreciated. Thanks. Attached is a shortened example of what I'm referring to.
Attached Files
File Type: xls Excel Question.xls (17.5 KB, 11 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using IF and Vlookup functions Assign functions to F1, etc. ibclare Office 4 06-02-2011 03:22 PM
Using IF and Vlookup functions Message Rules and Automatic Functions RogerM Outlook 2 02-27-2011 06:44 AM
Using IF and Vlookup functions ** Using Functions djreyrey Excel Programming 10 02-08-2011 04:18 PM
Automated Functions?? nickypatterson Outlook 0 08-27-2009 01:50 PM
How to show help for addin functions? Movses Asatryan Excel 0 03-02-2006 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:48 PM.


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