Snasui Excel Forum

Hi Dear,
In this example I have attached I have a Form with a drop down window with the options to fill the spot "click on steve smith and you have the option to select the other names". I would like excel to automatically fill in the Email, phone, and CFI certificate # in the respective boxes when I select the Recommending instructor name.
Thank you
Note:I use M365

...


C12

=VLOOKUP($C$11,Data!$J$4:$M$7,ROWS($C$2:C3),0)

Then copy the formula down.

Norkaz

thanks but how we can dynamic array for office 365?

sna wrote: Sat Oct 22, 2022 7:45 pm dynamic array for office 365

Cell C12 enter this formula,

=VLOOKUP($C$11,Data!$J$4:$M$7,ROW(2:4),0)

Thank you, that's it