Re: Question that should be easy but is geting on my nerves :)

Tech-Archive recommends: Speed Up your PC by fixing your registry

You said ... but if C-8 were B it should use a similar formula but in a
different cell area but same circumstance ... but didn't say what that cell
was so I took a pot at H99. Change it to suit.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hemmiv Iceland" <HemmivIceland@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9895A11B-F1D1-4222-A543-15AC5479FF89@xxxxxxxxxxxxxxxx
> Hi Bob an thank you for your reply, what do you mean with 99?
>
> "Bob Phillips" wrote:
>
> > C12:
=IF(C8="A",INDIRECT("'Sheet2'!H"&4+C10),INDIRECT("'Sheet2'!H"&99+C10))
> >
> > the 99 is a guess as you do not say
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Hemmiv Iceland" <Hemmiv Iceland@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
> > news:0EB3D1D0-AB12-4CAC-A75E-FE7A60A0BE68@xxxxxxxxxxxxxxxx
> > > Hello and thanks for looking and helping on this problem:
> > >
> > > I have been trying to find a formula that could help me with this
problem
> > > I have 2 drop down list one ranging from 1-10 in C-10 and in C-12 I
wanted
> > > to have a formula that would get the right number from another ***
in
> > h-5
> > > to H-14 (all numbers) in my simple mind it would look something like
this:
> > >
> > > If C-10 is 1 use cell in other work*** H-5
> > > If C-10 is 2 use cell in other work*** H-6
> > > and so on to 10
> > >
> > > but in the other drop down list I have names (C-8) and lets say that
the
> > > names are A and B if I use A the formula in C-12 should use the above
> > formula
> > > but if C-8 were B it should use a similar formula but in a different
cell
> > > area but same circumstance ?
> > >
> > > Is this possible???
> > >
> > > Thank you for hearing me out and sorry for the spell
> > > (Not from an English speaking country)
> > > Hemmiv
> >
> >
> >


.

Quantcast