Formula Excel (drop down list) - Microsoft Community

hi everybody, here's thing.

i've got excel problem. i'm making drop down list names of clients, need make cell where--> when name of client selected in drop down list above fills rif number specific column.

like this, when select client "a" in drop down list on cell b1, on cell b2 named "rif" fill respective number on cell h3.

i tried "if" formula , went =if($b$1=$g$3;$h$3;"") showed me 1 data client "a", if type client b drop down list stays blank.

please help!!

in b2 enter formula

=lookup($b$1,$g$3:$g$7,$h$3:$h$7)

if table not sorted use formula

=vlookup($b$1,$g$3:$h$7,2,false)

gord

Office / Excel / Windows 10 / Office 2016