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

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 sheet 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 worksheet H-5
If C-10 is 2 use cell in other worksheet 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

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

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 wrote in message
...
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 sheet 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 worksheet H-5
If C-10 is 2 use cell in other worksheet 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

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

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 wrote in message
...
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 sheet 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 worksheet H-5
If C-10 is 2 use cell in other worksheet 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

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

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" wrote in message
...
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 wrote in
message
...
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 sheet
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 worksheet H-5
If C-10 is 2 use cell in other worksheet 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

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

Hi Bob thank you for you reply but Excel says that the formula is not working
even if I change the H99 to H18 where the figures are? what could be wrong?
Where should I swich out the A and B to the names that are there?

Thank you.

"Bob Phillips" wrote:

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" wrote in message
...
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 wrote in
message
...
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 sheet
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 worksheet H-5
If C-10 is 2 use cell in other worksheet 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

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

This works fine for me

=IF(Sheet1!C8="A",INDIRECT("'Sheet2'!H"&4+Sheet1!C 10),INDIRECT("'Sheet2'!H"&
18+Sheet1!C10))

--

HTH

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


"Hemmiv Iceland" wrote in message
...
Hi Bob thank you for you reply but Excel says that the formula is not
working
even if I change the H99 to H18 where the figures are? what could be
wrong?
Where should I swich out the A and B to the names that are there?

Thank you.

"Bob Phillips" wrote:

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" wrote in
message
...
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 wrote in
message
...
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
sheet
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 worksheet H-5
If C-10 is 2 use cell in other worksheet 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