Carl Stephens
New Member
- Joined
- Jan 3, 2017
- Messages
- 46
- Office Version
- 365
Hello All,
I am looking for a formula that will look up data in cell B2, in row 4 (array is B4:AG13) and when it finds cell with the matching data to then search for the cells with X's in and then return data in column B in the same row. In the example below, the results are in cell B15:E15. Any help on this one will be appreciated. Thank you.
I am looking for a formula that will look up data in cell B2, in row 4 (array is B4:AG13) and when it finds cell with the matching data to then search for the cells with X's in and then return data in column B in the same row. In the example below, the results are in cell B15:E15. Any help on this one will be appreciated. Thank you.