Return values if other cells meet criteria

I am trying to return a list of computer names and possibly Windows build version and memory available if build version is less than X and memory is less than X.

Lookup-Reimage-Replace.jpg

So ideally on Sheet 1 (Overview) I would show the following:

FailedWin10ReplaceReimage.jpg

So if the computer has less than say 15 gig of ram AND has older than Build # 19042 build number of Windows we would return "Replace" on it.**

If the computer has over 15 gigs of ram and the Build # is older than 19042 we would say "Reimage"

I hope this is clear enough.