I have a table with 2 columns of data as shown in sample
below.

Col-A Col-B
Apple A
Pear P
Orange O

In a Cell say D1, I used "Data" - "Validation" to create
a dropdown box (combo box) by sellected Col-A as list
which allow me to select from Col-A. However, what
function I can use at the same to also return to me the
corresponding value in column-B instead of the selecte
item ?

E.g Select Pear, the function returns to me letter P.

Any assistance is greatly appreciated.