Looking for a formula to search a number of columns and rows, if they find a exact match to bring value of column A back.

This will be a large sheet with hundreds of rows down and approx 6 columns.