Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula help
Hello all,
I am trying to create a formula that will take the information in the column to the left and fill in the cell with the information in the right column. For example, I have the following: R/C FACTOR 1 35 2 36 3 37 4 38 6 39 7 40 8 41 9 41 10 42 12 43 13 44 15 45 16 46 17 47 18 49 20 50 21 51 22 53 23 54 24 56 25 57 26 58 28 60 29 61 30 63 31 65 I need the formula to take the RC value that I type into one cell and put the corresponding Factor in the formula cell. So if I type 1 in the cell, the formula would compute it to be 35, if I type 30, it would say 63. How would I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula help
The following formula looks up data
=VLOOKUP(C2,$A$2:$B$27,2,FALSE) C2 respresents the number you typed into a cell. The formula needs to be in a separate cell. Note that the range A$2:$B$27. It is in absolute format with the $ signs. Suggest you see help for more info on VLOOKUP and also absolute. Regards, OssieMac "Duckyspawn" wrote: Hello all, I am trying to create a formula that will take the information in the column to the left and fill in the cell with the information in the right column. For example, I have the following: R/C FACTOR 1 35 2 36 3 37 4 38 6 39 7 40 8 41 9 41 10 42 12 43 13 44 15 45 16 46 17 47 18 49 20 50 21 51 22 53 23 54 24 56 25 57 26 58 28 60 29 61 30 63 31 65 I need the formula to take the RC value that I type into one cell and put the corresponding Factor in the formula cell. So if I type 1 in the cell, the formula would compute it to be 35, if I type 30, it would say 63. How would I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |