can I automatically populate cells with non numerical text

[sproatd]

	(A)	(B)	(C)	(E)
(1)	5900	Miscellaneous Sales	$12.00
(2)	4500	Sales Tax <tbody> </tbody>	$0.84
(3)	5600	Membership Dues <tbody> </tbody>	$150.00
(4)	5900	Miscelaneoous Sales <tbody> </tbody>	$50.00
(5)	4500	Sales Tax <tbody> </tbody>	$3.50

<tbody>
</tbody>

When I type into column (A) I would like it to automatically populate column (B) with non-numerical text based on the value in column (A). Is it possible to do this in Excel?

 

[hateme28]

you could use an if statement for each cell in column B.. and keep going for each of your values.

=IF(a1=5900,"Miscellaneous Sales",IF(a1=4500,"Sales Tax",)

 

[sproatd]

Thank-you for responding. It would end up being an extremely long if statement and probably faster in the long run to just stop being lazy and type it in myself. I do appreciate your response though.

 

[xpluto]

Easiest way is to create an index table in a separate workbook and use Vlookup on Column B

so in a separate workbook (I will name it "Index") you will have something like this:

A	B
Code <tbody> </tbody>	Description <tbody> </tbody>
4500 <tbody> </tbody>	Sales Tax <tbody> </tbody>
5600 <tbody> </tbody>	Membership Dues <tbody> </tbody>
5900 <tbody> </tbody>	Miscelaneoous Sales <tbody> </tbody>

<tbody>
</tbody>

then in your Cell B2:
=vlookup(A2,index!A:B,2,0)

Copy the formula as you go down the list.

hope this help

V