Google Sheets is garbage! You cant even check for conditons

File: download.jpg (10KB, 267x189px) Image search: [Google]

10KB, 267x189px

Google Sheets is garbage!

You cant even check for conditons in one field, if TRUE input result in another field and of False ignore and repeat to form a list of only trues, without getting blank spaces in the FALSE ones.

In other words

TLDR; Google Sheets, need to parse info from one tab to another, only getting the TRUE fields to have input (and from another column than the TRUE) and doing this in a list without getting blank inputs from the FALSE results.

If 'Sheet1'!A 5 = Yes I need an outout with 'Sheet1'!DD5 and if FALSE, I need it to ignore that first row and check the next, without getting an output to DD5. If 'Sheet1'A44 turns out to be Yes, I need that to go into 'Sheet1'DD5 still

How the hell do I do this? I tried VLOOKUP, INDEX/SMALL and skipping a row, but nothing gives an answer.