Please see attached sample. Im hoping someone can recommend either a formula or a macro that will do the following:
Once a position is selected from the data validation drop down list in sheet1, the person/s name and salary will populate starting in columns B15 and C15. For example, if Waterboy is selected, both John Doe and Brad Pitt's name and salary would appear. If quarterback is selected, the names would clear and only Tom Cruise's name and salary would appear.
Thank you for any assistance in advance!