Apologies to you all,

I mean that I have a row of 7 cells say N7:T7 for each use of the solution
it will progress down the sheet, N8:T8, etc.
I need the value in whichever cell has the number so that I can take it to
another formula and use it to find a value. like this
21
2
6
3
11 3
5
2
2
49 30

elsewhere in the workbook column N has a value, column M has a different
value and so on. My thinking was that if I could identify the column the
figure was in, i would be able to then tell my formula which value it had to
use to multiply with the value here and produce my result. i.e. 21 in cell
P7 means 21*2.2 = 46.2

I then have the added issue of if a row has more than one number but I was
trying to have some help and also to try and work things out for myself
rather than be lazy and simply ask for the whole answer. Sorry if I've done
wrong by that.

Chris



"Chris" wrote in message
...
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