hi, i need to make a chart, i have a piece of paper with numbers 2-234, corresponding to each number there is a value starting with 60 for 2 and going up to 46488 for 234, i am going to create a side chart in my worksheet with all these values typed in.
in my main chart i want to have 2 columns, one a user input, and the other a formula generated one.
if i type 87 into cell a1 i want cell b1 to return the corresponding value taken from the side-chart....
i know this is pretty simple, i just cant grasp what needs to be done.
any help would be appreciated
Bookmarks