ineedadedt
Board Regular
- Joined
- Jan 7, 2004
- Messages
- 163
All,
I think this is a basic V-look up function, but I am not very familiar with it, so I am not 100% sure. I did some searches on here, but they seem to give me very specific explanations of it.
Here is the problem I have:
Cells E39:E47 and F:39-F47 are the beginning and end of a range.
Example:
E40=160% and F40= 174.9%
E41=150% and F41=159.9%
G39:G47 are points that correspond with the range of numbers from E39-E:47 and F39:F47.
H39:H47 is the payout
I am looking to get the payout from H39:h47 in cell L39.
Can someone help me with the vlookup statement or if there is an easier way to do this.
Thanks!
Eric
I think this is a basic V-look up function, but I am not very familiar with it, so I am not 100% sure. I did some searches on here, but they seem to give me very specific explanations of it.
Here is the problem I have:
Cells E39:E47 and F:39-F47 are the beginning and end of a range.
Example:
E40=160% and F40= 174.9%
E41=150% and F41=159.9%
G39:G47 are points that correspond with the range of numbers from E39-E:47 and F39:F47.
H39:H47 is the payout
I am looking to get the payout from H39:h47 in cell L39.
Can someone help me with the vlookup statement or if there is an easier way to do this.
Thanks!
Eric