formulas in excel
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.
|