Return Value

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

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
 
Take a look at VLOOKUP. Name your table of data in C:D (eg C1:D100) 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)
 
Back
Top