Is there an IF statment equivalent to SumIFS?

I have a spreadsheet with a tab that has my data in a database format.    I need to write an if statement that will search a column of data and return a value from a different cell within the same re...