VLookup with IF formula reference another worksheet

[drop05]

Hello, I am having trouble trying to come up with logic to make this happen. So i have an idea of using a vlookup
where im thinking of the vlookup looking partially like this but all in one
=VLOOKUP(D7,'List'!$G:$Z,19,FALSE)
=VLOOKUP(D7,'List'!$G:$Z,20,FALSE)

the IF part id like to add is that
with this vlookup with the column index being 19, if that cell value is "X" then the value in which this formula would be located would be "Unrelated"
but if the value of vlookup with the column index 20 if that value is "X" then the value in which this formula would be located would be "Related"
if both of the column index 19 & 20 if they are both "X" then the value in which this formula would be located would be "Both above"

if there is no X in either and they are "" then the value in which this formula would be located would be "Blank"


hopefully i made sense, but maybe you can see why im also lost
any help would be appreciated!

 

[Fluff]

How about

=LET(v,VLOOKUP(D7,List!G:Z,{19,20},0),t,TEXTJOIN(" ",0,v),IF(LEN(t)=3,"Both above",IF(LEN(t)=1,"",IF(LEFT(t)="X","Unrelated","Related"))))

 

[drop05]

How about

=LET(v,VLOOKUP(D7,List!G:Z,{19,20},0),t,TEXTJOIN(" ",0,v),IF(LEN(t)=3,"Both above",IF(LEN(t)=1,"",IF(LEFT(t)="X","Unrelated","Related"))))

This is awesome! Curious, if both 19 and 20 are Blank like no value in either, is there a way to get the text "Blank" to come out from the formula?

 

[drop05]

How about

=LET(v,VLOOKUP(D7,List!G:Z,{19,20},0),t,TEXTJOIN(" ",0,v),IF(LEN(t)=3,"Both above",IF(LEN(t)=1,"",IF(LEFT(t)="X","Unrelated","Related"))))

Wait you can cancel that i see the logic there just put Blank where it is len(t)=1,""

 

[Fluff]

Glad you sorted it & thnaks for the feedback.

 

[drop05]

How about

=LET(v,VLOOKUP(D7,List!G:Z,{19,20},0),t,TEXTJOIN(" ",0,v),IF(LEN(t)=3,"Both above",IF(LEN(t)=1,"",IF(LEFT(t)="X","Unrelated","Related"))))

Thank you so much! I need to look into what the text join and Left, i have not used that much