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