How do i make Multiple If & 1 And Statement

So i have looked over and over for a proper answer on this, but I am having a hard time piecing everyone else's formula together into mine, if Someone could help me with the formula it would be much appreciated.
Basically its a form that says weather someone is suspended or on Leave of Absence or neither and relays it to our roster.
E F G H I
LOA / Suspended Your Name Their Name Start Date End Date

Currently the Formula i have is

Please Login or Register  to view this content.

(If todays date is between start and end date show end date)
Which does a okay job at telling me if they are currently on LOA, and returns the ending date.
Now im adding suspended to this form, so i need to Add
If E = "LOA" Then IF(AND(TODAY()>=H2,TODAY()<=I2),"LOA"I2,"" (If E says LOA Then check if Todays date is between start and end and if it is show "LOA" End Date)
Otherwise see if
If E = "Suspended Then IF(AND(TODAY()>=H2,TODAY()<=I2),"SUSPENDED"I2,"" (If E says Suspended Then check if Todays date is between start and end and if it is show "Suspended" End Date

I understand the code may need to be written but i can't seem to find a method in doing this.
Thank you

I tried something similar and it didn't work, unfortunately neither did this it gives me a formula phase error, thanks for the try though

That actually works khal thanks!.
And when it display "Text" and date i then run a index search with a list of names and once that is done it imports it to another document with the name and dates.
Now my problem is how to make 2 Index & Match statements in 1 cell. im stuck here.

Please Login or Register  to view this content.

Post a sample file not image) showing expected outcomes.

Alright so here's the link, [l
ink]https://docs.google.com/spreadsheets/d/1FLSvgT8yfCE7l2V4nLE7ZutWElA8VuILQyZo_6S-PaU/edit?usp=sharing[/link]
Basically there is a tab for "LOA Responses" There is a google Form that submits information here

Then there is a Suspension Responses, There is also another google form that submits information there.

Then there's the summary.......
Basically there's the Name List And Position, The Column "C" is a Index & Match for column K & S
And if they are filled will that person's name it will fill in that info from that column.

I can get it to work for 1 column but im not sure how to match 2 columns. my attempt is C3 &C5
C17 is a working Example of it Matching 1 Column and working

Of course this is just a copy so feel free to edit anything if you need to test it

Completely confused as what you expect to get in but try this ...

=IFERROR(INDEX($K$1:$K1001,MATCH(A5,$G$1:$G1001,0)),IFERROR(INDEX($S$1:$S1001,MATCH(A5,$N$1:$N1001,0)),""))

Originally Posted by JohnTopley

Completely confused as what you expect to get in but try this ...

=IFERROR(INDEX($K$1:$K1001,MATCH(A5,$G$1:$G1001,0)),IFERROR(INDEX($S$1:$S1001,MATCH(A5,$N$1:$N1001,0)),""))

You Got it! Awesome, Thank you so much, i know it was confusing