L
lukedall
I need help in filling in the value of a cell in a worksheet based on the
value in other columns. I have a worksheet that has a series of columns.
In each instance there is data in the first two columns and I need to
automatically fill in the value of the cells in the third column based on
the value entered in a cell in the fourth column which will match the value
of a cell in column 1.
Using the the example table If I enter a 5 in the first cell of column 4,
then the matching cell of column three would fill in with 19. I have tried
several approaches and none have worked. Any suggestions will be
appreciated.
value 1 value 2 value 3 value 4
1 2
2 5
3 9
4 14
5 19
6 25
7 31
value in other columns. I have a worksheet that has a series of columns.
In each instance there is data in the first two columns and I need to
automatically fill in the value of the cells in the third column based on
the value entered in a cell in the fourth column which will match the value
of a cell in column 1.
Using the the example table If I enter a 5 in the first cell of column 4,
then the matching cell of column three would fill in with 19. I have tried
several approaches and none have worked. Any suggestions will be
appreciated.
value 1 value 2 value 3 value 4
1 2
2 5
3 9
4 14
5 19
6 25
7 31