| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
one cell in a row contains a number
I have a fixed row of 7 cells, any one of which might contain a number. the
cell with the number is the relevant one and it will determine my formula; i will want to multiply the cell value by a number in another cel which is chosen according to the number of the cell in the original row. eg A1:A7- A3 contains 21 formula in A50 will wish to determine 21 x value of cell in column 3 of a range of columns because the number 21 is in cell 3 in the row. I was planning to use V or HLookup I think but cant fathom how to get the cell number form the original row. TIA Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
Threaded Mode
