Thread: Using IF and Vlookup functions
View Single Post
 
Old 12-14-2011, 12:31 PM
cpladson cpladson is offline Windows XP Office 2007
Novice
  
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