matching values based on criteria and return values from another columns

I have data consists of 4 columns. I would like to return the value in column1 and column4 based on the criteria (1) if column2 match user inputs valude, (2) column 3 equals to D, and (3) column 4 <= 3. I have tried lookup and match and couldn't seem to make this to work. Wonder if this need to be done in VBA or using Excel formula?

I appreciate any advice / help anyone can provide. Thank you much.