Looking up a value

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top