I need BIG help with with formula

T

Terry

When i enter a number in "G" from "K" i need "H" in that row to equal what
the number is straight across from "K" in "L".





G H I J K
L
5-- GAUGE BBLS. BWH REMARKS Inches Bbls.
6 1 4
7 2 9
8 3 13
9 4 18
10 5 22
11 6 27
12 7 31
13 8 36
14 9 40
15 10 45
11 49
12 53
13 58
14 62
15 67
16 71
17 76
18 80
19 85
20 89
21 94
22 98
23 103
24 107

thanks
 
D

David Biddulph

It's difficult to see from your posting what your data structure is, but try
=VLOOKUP(G6,K$6:L$24,2). Adjust the formula to suit; details of the
VLOOKUP function are at Excel help.
 

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