Hello everyone,
I have a name drop down list in A1 with the drop down information in H1:H15. I have a corresponding phone number list in I1:I15.
If A1=H1, then B1=I1, or A1=H2, then B1=I2....etc.
I have tried =IF(A1=H1,I1," ") and get the result but I do not know how to add H2 through H15 or the corresponding I2 through I15 so that when another name is selected, it's corresponding number populates B1.
Thank you for your help because I'm sure this would be considered "elementary" by most.
Bookmarks