XLDriver
06-10-2010, 11:04 PM
I'm new to the more complex formulas for MS Excel. I have a project that when I insert a value in one cell a corresponding different value is automatically inserted in the cell next to it. for Example, If 100 is entered in
A1 then 34751 would automatically be entered in B1. If 200 is entered in A1 then 69502 is automatically entered in B2, etc. There are a total of 68 variables for A1 with each variable having a corresponding value for B2.
Does anyone know how to write this formula so it will work?
Better Yet, if there was a drop down menu for A1 that had the values
100
200
300
400
etc.
and when the value was selected, a corresponding value was entered
automatically in B2.
Thanks for any help you may have!
A1 then 34751 would automatically be entered in B1. If 200 is entered in A1 then 69502 is automatically entered in B2, etc. There are a total of 68 variables for A1 with each variable having a corresponding value for B2.
Does anyone know how to write this formula so it will work?
Better Yet, if there was a drop down menu for A1 that had the values
100
200
300
400
etc.
and when the value was selected, a corresponding value was entered
automatically in B2.
Thanks for any help you may have!