Tatsukun Wrote:
Hi all, I hope you can help an old dog learn a new trick here. I have a
list of 20 values for X, and thier matching Y values. Now, what I need
to do is find a way to get a formula so I can put in a different X and
get a Y.

I hope that's specific enough, I'm not sure how open I can be with this
data.

I am using Excel 2000.

Thank you all in advance!

-Tatsu

ASSUME that:

Cells A1:A20 contain your X values and
Cells B1:B20 contain the corresponding Y values
Cell C1 is where you will enter the X value

Given the above assumptions, your formula is (enter, say, in Cell D1):

=VLOOKUP(C1,A1:B20,2,0)

Hope this is the formula that you are looking for.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=374752