I would like to update cells in the same row based on a selection in the dropdown list in the same row. I currently have a Vlookup to a range for all cells in the 3 columns I want to update. I would like to remove the vlookup and only change the data when another selection is made in the dropdown list.

For example:
Column B = the dropdown
Columns C, D and E =populate data based on changed selection in the column B dropdown.

I do not want other row data in columns C, D and E to change. Only the row where the dropdown selection changed.

Thanks in advance!