i need to pull information from a cell on another sheet (sheet 2) onto sheet 1 based on criteria from another range of cells on sheet 2. i tried to do an if formula but i couldn’t quite figure it out.

​i need to pull information from a cell on another sheet (sheet 2) onto sheet 1 based on criteria from another range of cells on sheet 2. i tried to do an if formula but i couldn’t quite figure it out.   Read More

​