Lookup column

[cmar6]

Is there a way to return the value of the cell in column H based on the value in column M, e.g., if value in col M. is greater than 1% or less than -1%, then return the value in column H; otherwise, return a blank cell.

[daddylonglegs]

Try this for row 2

=IF(ABS(M2)>1%,H2,"")

[cmar6]

Try this for row 2

=IF(ABS(M2)>1%,H2,"")

This worked very well, thank, CMA