| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Threaded Mode
