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