Price and # of Jobs based on drop down

[Wskip49]

I'm trying to get the Price and # of Jobs to auto fill data from # of Job tab based on date or the Invoice#.
I have tried Vlookup(Indirect, IF Statement, Vlookup, I'm all out of ideas.

[CK76]

In D14:
=INDEX('# of Jobs'!$C$4:$F$5,MATCH($E$4,'# of Jobs'!$B$4:$B$5,0),MATCH([@Column1],NOJ_2[[#Headers],[Exterior Underwriting]:[Gas]],0))

Copy down. Though I'd recommend creating named range(s) for '# of Jobs' sheet. Or flattening out data.

[Wskip49]

Thank you so much.