Return Value

[Kenneth]

I have in column "A" values that will be selected using a dropdown list
from values in column "C" I have corresponding values in column "D"
that abbreviate the value in column "C". When selecting a value for
Column "A", i want the value from Column "D" to automatically populate
column "B".


A B C D
Abu Dhabi TC Abu Dhabi TC

A is a dropdown list based on column C, when A is selected, I want to
get the corresponding abbreviation from column D and put in column B.

Thanks

 

[Ken Wright]

Take a look at VLOOKUP. Name your table of data in C (eg C1100) as MyTable, and then in say
B2, put a formula like the following:-

=VLOOKUP(A2,MyTable,2,0)

Without the naming it would be something like:-

=VLOOKUP(A2,$C$1:$D$100,2,0)