auto complete text from data in another cell

I have a list of titles of accounts and a list of account numbers. I want a person to be able to pick from data validation drop down box in A1 from a list I have in say I1:I17 which is a list of titles to accounts. I then want B1 to automatically complete the account number that corresponds in the list I have in say J1:J17.

I want be be able to do this in B1, C1, D1, etc. (12 rows)

School 123456
Home 234567
Work 345678

I thought the following link worked for me but it does not.
http://www.excelforum.com/excel-form...ther-cell.html If a cell contains a certain text then put a specified text in another cell?
=IF(ISNUMBER(SEARCH("16x20",A2)),"Baseball,BaseballPhotos16x20" ,IF(ISNUMBER(SEARCH("8x10",A2)),"Baseball,BaseballPhotos8x10",""))

I do not know if I just can't figure out how to add the other items because this only list two items. Any help would be appreciated.

Try

=VLOOKUP(A1,$I$1:$J$17,2,0)

Works perfectly - THANK YOU - thrilled, I am

@ godleyhdg

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.