Hello! I have a minimal understanding of Excel, and am trying to create a formula that will permit me to select the value from the cell to the left of to another cell that may (or may not) be present in a range of cells within a row.
Attached is a sample file. My goal is to create a formula in cell AP that states, "If the value '101' is found within the range of cells C2 - AO2, put the value from the cell to the left of 101 into cell AP." I am then going to duplicate this formula for different conditions (cells AQ - BV), and then for a variety of ranges.
Thanks so much for your help!
Becca
Attached is a sample file. My goal is to create a formula in cell AP that states, "If the value '101' is found within the range of cells C2 - AO2, put the value from the cell to the left of 101 into cell AP." I am then going to duplicate this formula for different conditions (cells AQ - BV), and then for a variety of ranges.
Thanks so much for your help!
Becca