I would like to know if anyone can help!! I need to know if it is possible
in excel to to the following:

I have separate cells G E B. These cells then refer to a key for G E B etc.
alongside these letters in separate cells I have a figure ie £10.00.

But each time or every month these cells change the order in which they are
in. So I am looking to ask in the total cell box if the letter in cell A3 is
equal to G then go to H1 for the answer. If the letter in cell A3 is equal
to E then go to H2 etc. Have this for A to I. It is difficult to explain.

But if anyone can help or suggest where I can get help from.

=IF(A3="G",H1,IF(A3="E",H2,H3))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"p3charmed3" wrote in message
...
I would like to know if anyone can help!! I need to know if it is possible
in excel to to the following:

I have separate cells G E B. These cells then refer to a key for G E B
etc.
alongside these letters in separate cells I have a figure ie £10.00.

But each time or every month these cells change the order in which they
are
in. So I am looking to ask in the total cell box if the letter in cell A3
is
equal to G then go to H1 for the answer. If the letter in cell A3 is
equal
to E then go to H2 etc. Have this for A to I. It is difficult to
explain.

But if anyone can help or suggest where I can get help from.