KyleJackMorrison
Board Regular
- Joined
- Dec 3, 2013
- Messages
- 107
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hello,
I have the following table in columns
A, B ,C
I would like the formula that will be in 'E1' to return the cell in column 'A' if the cell is '1' in column 'C'.
So for example the formula would return 'DDR3' as its '1,600 MHz'
Can't seem to find how to search the range and then return the adjacent cells.
many thanks,
Kyle
I have the following table in columns
A, B ,C
I would like the formula that will be in 'E1' to return the cell in column 'A' if the cell is '1' in column 'C'.
So for example the formula would return 'DDR3' as its '1,600 MHz'
Can't seem to find how to search the range and then return the adjacent cells.
many thanks,
Kyle