Formula/Function Assistance Please!

Hello,

Please forgive my terminology as it may not be on point as say an expert might be. Anywho, I'm having issues trying to come up with the best lookup formula for my workbook. I've attached it so you can see what I'm working with. On the Daily Board tab, I need a formula in cell G5, for example. It needs to do 2 separate lookups based on 2 different criteria for each on 2 different sheets. I know vlookups don't typically do multiple criteria unless you use helper columns and/or concatenate. Basically, G5 needs to look up the date in D2 and the KLN in C5. It needs to return the demand number from column E on the order.txt tab. The order.txt tab will be an ever growing list so there will be duplicates of the same KLN, but the date will change so it will need to pull the correct demand number based on the date as well as the correct KLN. The second lookup is the same thing, but using the fcst.txt tab. Same columns apply, and it's an ever growing list, etc. Essentially, it needs to be an IF statement to where if the date on the order tab matches the date on the Daily Board tab, then it needs to give me the demand number from the order.txt tab. If it does not match, then it needs to give me the demand number from the fcst.txt tab instead. I don't know if I'm running into a formatting issue or what, but my brain is mush at this point. Any and all help is appreciated.