Data Validation dropdown list with concatenated values

[CFury]

hi, i wonder if this is possible to concatenate values of table/list in dropdown.

lets say you have 2 columns

A	       B
green      3
blue       2
red	       1

with this range
$A$1:$A$3
in Data Validation, we get list

green
blue
red

how to make it to also contain values from column B?
like this for example

green 3
blue 2
red 1

or even with extra formatting

green (3)
blue (2)
red (1)

[karolus]

Hallo
→→Data→Validation →→Allow→→CellRange: $A$1:$A$3 & " ( " & $B$1:$B$3 & " )"
or better: $A$1:$A$3 & TEXT($B$1:$B$3;"( 0 )")

[CFury]

Thanks very much, worked like charm!