Trying to make the result of an "IF" formula appear in a different cell

[Marlow212]

Learning this as I go. I'm trying to make the result of my IF formula appear in a different cell than the one the formula is in. I'm trying to pick a Company name from a Combo Box and when I do, I want the Address of that company to appear in a form (Excel spreadsheet) I've created. I can do it with nested IFs in Excel 2013, but I'm using 2003 and it doesn't allow for more than 7 nested IFs. Here's what I want to do. Cell A1: (any number 1-10); Cell B1: Text; Cell C1: IF A1=(any number 1-10), put B1 into B2. Is this even possible?
Thanks for any help you can give.

[Ace_XL]

Maybe..

In B2

=IF(AND(A1>=1,A1<=10),B1,"")