Replace cell info based on cell address/criteria

[Tjfinley]

Hey everyone. I am creating a vendor information file and want to have the ability to change the info in the spreadsheet from my lookup. For example… passwords. When I need to change a password, I want to type in the vendor name and school and my index formula will pull up the additional info. Then I want to be able to type in the info I would like to replace in that cell (C16), without having to directly go find the cell that I would like to change.

Thanks.

[gijsmo]

I've taken a look at the sample file and instructions and attached one way of achieving this.

I've also made some modifications that may help. The Vendor name in Cell C2 is now derived from a combobox dropdown list, when you select from this list it will populate the rest of the cells in C3:C10.
The combobox is kept up-to-date via a worksheet change event.

It is probably unnecessary to replicate the vendor/school etc information below this in the PASSWORD CHANGE section however, I have kept this in place.

The actual replacement of the password happens via the Replace button below the PASSWORD CHANGE section. The macros can be found in the Sheet1 code.

[Tjfinley]

Thank you so much! Have a good day