|
|
#1
12-14-2011, 12:31 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Assign functions to F1, etc.
|
ibclare | Office | 4 | 06-02-2011 03:22 PM |
|
Message Rules and Automatic Functions
|
RogerM | Outlook | 2 | 02-27-2011 06:44 AM |
|
** 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 |
Windows XP 
Office 2007
Threaded Mode