Using IF and Vlookup functions

[cpladson]

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.

[Pecoflyer]

Hi

In B2 enter

=VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE)

and pull down as needed


EDIT to be complete , in XL 2007 you can use

=iferror(VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE),"")

and in XL 2003

=if(isna(VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE),"",VLOOKUP(A2,'tab 1'!$A$2:$B$11,2,FALSE))

[cpladson]

Thanks, that worked in my attached spreadsheet, however when I implemented that into my actual spreadsheet I'm working on I get #REF or #N/A errors. Says that A2 has a constant. I'm not understanding why if I was able to get it to work in my example spreadsheet but not my actual.

[Pecoflyer]

The NA error should not appear if you use the error catching formula

As for the REF error it could be the column index that is faulty.
Try the " Evaluate formula" in the Formulas tab of the ribbon and see what happens