I have an excel file with many columns that denote fields, like in a database

Can I search for an ID in a particular column, and once the ID is found, modify a cell of another field in the same row as the ID just found? Anybody done this before?