Multiple Formulas in one cell

[dustyd]

Im an English teacher and i want to select a lesson by the unit number(cell C3) and the lesson number(cell D3)
when i select the unit and lesson it must pull up the lesson info from cells A23-A46
and display it on my note cell(cell G3)
here is my formula and it works just the way i want it to but i cant put multiple formulas next to it.


=IF((C3=1)*(D3=1),A23,)

so the value of c3 is 1 which is unit 1 and the value of D3 is 1 which is lesson 1 so that must display info from cell A23.

I want to be able to select any value and it must display the info relevant the note cell from A23-A46


all Im asking is for multiple formulas that are the same with different values and can select the relevant info for that value in one cell.

thanks in advance
regards

 

[gaz_chops]

Instead of =1 why nor reference a cell with a number that you can change?

 

[MarcelBeug]

How would Excel know which value in A23-A46 belongs to which unit/lesson combination?
I would expect unit and lesson adjacent to A23-A46 in B23-C46.

By the way I'm not a native English speaker.

 

[gaz_chops]

Read it again and it sounds like you need a lookup, post a sample of your data as it appears in your spreadsheet.

 

[dustyd]

I figured it out

so i needed to pull info from cells A21 -A44 and display it on my note slide when i put to values in from two different cells

here is my mess
it does exactly what i want it to do

thanks
for your input everyone

=IF((C7=1)*(D7=1),$A$21,IF((C7=1)*(D7=2),$A$22,IF((C7=1)*(D7=3),$A$23,IF((C7=1)*(D7=8),"Quiz",IF((C7=2)*(D7=1),$A$25,IF((C7=2)*(D7=3),$A$26,IF((C7=2)*(D7=8),"Quiz",IF((C7=3)*(D7=2),$A$27,IF((C7=3)*(D7=3),$A$28,IF((C7=3)*(D7=8),"Quiz",IF((C7=4)*(D7=3),$A$30,IF((C7=4)*(D7=8),"quiz,progress,PTM",IF((C7=5)*(D7=2),$A$33,IF((C7=5)*(D7=8),"Quiz",IF((C7=6)*(D7=1),$A$34,IF((C7=6)*(D7=2),$A$35,IF((C7=7)*(D7=2),$A$36,IF((C7=7)*(D7=4),$A$37,IF((C7=7)*(D7=8),"Quiz",IF((C7=8)*(D7=1),$A$38,IF((C7=8)*(D7=8),"progress,Quiz")))))))))))))))))))))

 

[gaz_chops]

There is probably a better way of doing it, but not without seeing a sample your data.

At least you're sorted

 

[MarcelBeug]

OMG.
You'd better put the unit-lesson in front of your notes.
Like
Col A Col B
1-1 Notes for lesson 1, unit 1
1-2 Notes for lesson 1, unit 2

If you complete the list in A21:B41, then in G3:

=INDEX($B$21:$B$41,MATCH(B3&"-"&C3,$A$21:$A$41,0))

Translated in English: pick the value from B21 through B41 where the corresponding value in column A equals the concatenation of lesson in B3 and unit in C3, separated by a hyphen.