Can anyone give me some advice with a formula for MS Excel. I have values of 100,200,300,400, etc. to be inserted in cell A1 and based on the selection, I need a corresponding number to be automatically placed in cell B2. This has to do with the weight & balance of an airplane. Cell A1 is the Fuel weight and Cell B1 is the Moment. There are 68 different choices for cell A1. Thank You!

I'm glad you know what your talking about, because I don't. You'll have to be a bit more specific.

What does your sheet look like, what cells are you using?

values of 100,200,300,400, etc. to be inserted in cell A1 and based on the selection, I need a corresponding number to be automatically placed in cell B2.So if 100 goes in A1, you want 100 in B2?

Cell B1 is the MomentDo you mean it's a time cell, like =NOW()?

How does that fit into the whole scheme of things?

MIKE

The form I have created has several cells in three columns for various values. Some of the cells I have been able to insert basic formulas (addition, subtraction, etc.) What I need help with is one cell where the pilot will insert the fuel weight in increments of 100 lbs. The Moment is a term for a linear value based on the Arm (distance from the front of the acft). It is a set value based on a weight and the arm.

There is a value that corresponds with each 100 lbs. for example:

100 = 34751

200 = 69502

300 = 103004

and so on . . to

6700 = 2206729

6790 = 2236955What I am trying to do is simplify the calculation of the weight and balance form that when a pilot puts in a weight value in a cell labeled "Fuel Weight" a corresponding value of that particular "moment" is automaticaly inserted in the adjacent cell.

The Moment value associated with the weight is derived from the airplane flight manual charts. I can send you a copy of the Excel Page that I have been working on if that will help.

Hope that clarifies it a little better.

There is a value that corresponds with each 100 lbs. for exampleCan this be calculated, or is it simply a list?

100 = 34751

200 = 69502

300 = 103004

How is the differences between the 100 values calculated?MIKE

You might want to look at this thread, it's a bit old, but does it give you the basics of what your looking for?

Is it something we can develop or expand?Don't try the link at the bottom, the page is blank.

http://www.eggheadcafe.com/software...

MIKE

It is simply just a list. 100 has set corresponding value. 200

has a set value and so on. No calculations to be done.If A1 is 100 then B1 is a set value

If A1 is 200 then B1 is a set value

etc.Does that make sense?

What I need help with is one cell where the pilot will insert the fuel weight in increments of 100 lbs.Try this:

A =VLOOKUP() should work nicely.

On Sheet 2 of your workbook, in column A list your weight table:

A B 1) 100 34751 2) 200 69502 3) 300 103004 4) 6700 2206729 5) 6790 2236955

On Sheet 1 cell B1 enter the formula:=VLOOKUP(A1,Sheet2!A1:B5,2)

When you enter a weight in Sheet 1, cell A1, this will fetch the

corresponding number from Sheet 2, column B.So if you enter 100 in A1, 34751 comes up in B1

Will that work for you?

MIKE

Put all of your possible A1 values in a list, let's say in C1:C68. Put all of your corresponding values in a list, let's say in D1:D68.

Put a Data Validation Drop Down list in A1, populated with the values from C1:C68.

In B1, put this formula:

=VLOOKUP(A1,$C$1:$D$68,2,0)

This will lookup the value selected by the A1 Drop Down in C1:C68 and return the corresponding value from the list in D1:D68.

Like the addition of a dropdown, makes things harder to screw up. Wish I had thought of it. MIKE

Thanks Folks! I'll try that tonight and see if I can't get this to work. I really appreciate the time you spent.

I just tried the suggestion you gave with the dropdown and it works great. Thank You Very Much! I never would have figured that out. Like I said, I am new to the Excel functions other than basic formulas. Now I have to research how to protect just certain cells so pilots using the form don't change any of the formulas or valuses within those cells.

It's all in the Help files. If you need help protecting cells, please start a new thread with a new question.

Ask Your Question

Weekly Poll