How to create a formula for a range of cells
 

I would like to select a range of cells and make a formula so that when I
input a particular number in them, the next column will fill in a name. I
have a total of 27 rows that will be included in this function. What is this
function called and is it do-able? Thanks.

Marathonrealty:

You'll need to post again with more details. I cannot picture what you
want.

1. What does your input data look like (dates, numeric values, text)?
2. What is the output you want to see?

You said you wanted to see names but I'm baffled what you mean by
putting in a range of numbers and they return a name.


--
nbrcrunch

You can use the VLOOKUP function to return data from a table. There are
instructions and examples he

http://www.contextures.com/xlFunctions02.html

Marathonrealty wrote:
I would like to select a range of cells and make a formula so that when I
input a particular number in them, the next column will fill in a name. I
have a total of 27 rows that will be included in this function. What is this
function called and is it do-able? Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I would like to avoid inputting each account name next to the account number
in a spreadsheet. So, I made a table (which is located at A39:B59). Now in
my function, I would like for the acccount name to be automatically entered
next to the corresponding account number. For ex:

Account Number Account Name
00254 Lawn Care
25782 Electrical Work
96845 Snow Removal

So, when I input "25782" into cell H2, I would like for Electrical Work to
be placed in I2 (and the same for the other 26 account names I have to use).
The function I have in cell I2 is:=VLOOKUP(H2,Account List!A39:B59,2,FALSE).
But this function does not work. What am I doing wrong? Please help!
Thanks....

"nbrcrunch" wrote:


Marathonrealty:

You'll need to post again with more details. I cannot picture what you
want.

1. What does your input data look like (dates, numeric values, text)?
2. What is the output you want to see?

You said you wanted to see names but I'm baffled what you mean by
putting in a range of numbers and they return a name.


--
nbrcrunch