Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill in columns
Is there anyway to expand the information in a column and its relation in the
next column? example, in column A, I have numbers 50, 52.1, 55, 58.8, 60, 65, 70, etc. (up to 20,000) in column B, I have a number I can divide them with to give me another system of numbers. the divisor of 50 is 4.66, 52.1 is 4.88, 55 is 5.13, 58.8 is 5.46, 60 is 5.52, etc. I'm building a form where I need to be able to have someone type in any number (not just the ones in the table), and it can find the divisor and divide to give them an answer. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill in columns
One way is to use a vlookup set for an exact match.
Assuming the source ref cols A and B are in Sheet1, then in another sheet, with the lookup values in say, A2 down you could place in B2: =IF(A2="","",A2/VLOOKUP(A2,Sheet1!A:B,2,0)) Copy B2 down to return correspondingly -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "widman" wrote: Is there anyway to expand the information in a column and its relation in the next column? example, in column A, I have numbers 50, 52.1, 55, 58.8, 60, 65, 70, etc. (up to 20,000) in column B, I have a number I can divide them with to give me another system of numbers. the divisor of 50 is 4.66, 52.1 is 4.88, 55 is 5.13, 58.8 is 5.46, 60 is 5.52, etc. I'm building a form where I need to be able to have someone type in any number (not just the ones in the table), and it can find the divisor and divide to give them an answer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |