XL97: formulae 2

[rotschreck]

I have a chart of numbers that I need to convert into a formula. The formula needs to be worked into the sheet in several places.<br>
<br>
If this #________Then this value<br>
1__________________3<br>
3__________________6<br>
6__________________9<br>
10_________________12<br>
15_________________15<br>
25_________________18<br>
40_________________21<br>
60_________________23<br>
75_________________25<br>
<br>
Can excel help to figure the proper formula? (example: x+5*45-x*3) <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a><br>

 

[Dreamboat]

I'm not sure I understand. What is the formula in your example? Could I assume that the numbers in your first column are in column A and the second column is B? Where are you putting the actual formula and what do the numbers and the letter x in your example indicate?<br>
<br>
If you have this in sheet2:<br>
<br>
Col A Col B<br>
Part # Price<br>
A123 1.00<br>
B243 2.00<br>
C345 3.00<br>
<br>
and you want to lookup up the price from sheet2, where you have typed the part number on sheet1 in cell A2, then you would type this formula in B2:<br>
<br>
=vlookup(a1,sheet2!A1:B4,2,False)<br>
<br>
and B2 will find the price.

 

[rotschreck]

your idea for vlookup is pretty close to the answer I'm looking for.<br>
<br>
I have ColA & ColB. Also, I have Num1 and Num2.<br>
What I need is to compare Num1 to ColA.<br>
If Num1 = 25, Num2 = 18<br>
If Num1 = 39, Num2 = 18<br>
If Num1 = 40, Num2 = 21<br>
<br>
As long as Num1 is betwee 25 and 39, Num2 will be 18. Is this possible?<br>
<br>
the example formula was just an example. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a><br>

 

[rotschreck]

Sorry, found this answer.<br>
Just change the lookup_range to TRUE.<br>
<br>
Thanks! <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a><br>