automatic fill-up columns

[jv]

Good day to all,

I have this spreadsheet for our weekly billings.

A B C D E
s/n Description Section Code Amount
Admin. E
Eng. A
Finance B
Eng. A
Acctg. C
HRD D
Admin E

From the above, Is it possible that whenever i type a
certain letter in column D, a corresponding section name
will appear in column C? Its just like assigning the
letter with corresponding name.

Hoping theres a way to make this possible.

Thanks and regards.


jv

 

[Frank Kabel]

Hi JV,

some ideas how to<solve this
1. Create a lookup table on an different sheet (lets say on Sheet2). In
Column A you store the different codes (A-??) in Column B you store the
corresponding section name.
2. In you master sheet you can enter the following in column C
(starting in row 2 -> cell C2):
=IF(D1<>"",VLOOKUP(D1,'Sheet2'!$A$1:$B$999,2,False),"")
copy this for all rows

HTH
Frank

 

[Ken Wright]

Use VLOOKUP and either create a little table somewhere that holds all the
values, or name an array with that data in it.

Assume your table of Section Codes was in A100:A110 and your Section Names were
in B100:B110, and that you have named that table MyTable (Optional but makes
life easier), then in say

C2 put the following formula and copy down as far as you think you will go:-

=IF(D2="","",VLOOKUP(D2,MyTable,2,0))

If there is nothing in cell D2 then there will be nothing visible in C2 and so
on, but when you put the code into D2, the name will appear in C2.

 

[jv]

Frank & Ken,

Thank you so much for your help, works great!!!

Its an additional knowledge for me.

jv

 

[Ken Wright]

A pleasure