can I automatically populate cells with non numerical text

sproatd

New Member
Joined
Sep 17, 2014
Messages
2
(A)(B)(C)(E)
(1)5900Miscellaneous 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?
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
you could use an if statement for each cell in column B.. and keep going for each of your values.

Code:
=IF(a1=5900,"Miscellaneous Sales",IF(a1=4500,"Sales Tax",)
 
Upvote 0
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.
 
Upvote 0
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:
AB
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
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top