Leonard010193
New Member
- Joined
- Aug 11, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Afternoon,
I have table made up of the following values
I want to be able automatically take the values in column B based on the value in column A.
So if I enter the value of 2.5 in cell C5 for example, I want cell C6 to automatically fill the value in column B next to the value 2.5.
So C6 should show the value 1 if cell C5 = 2.5
Any help would be amazing.
Thank you.
I have table made up of the following values
Column A | Column B |
2.5 | 1 |
4 | 2 |
6 | 3 |
10 | 4 |
I want to be able automatically take the values in column B based on the value in column A.
So if I enter the value of 2.5 in cell C5 for example, I want cell C6 to automatically fill the value in column B next to the value 2.5.
So C6 should show the value 1 if cell C5 = 2.5
Any help would be amazing.
Thank you.