Search a text and true/false in return

Hi! I am new with this kind of forum.

I want to search a text in a column (D) in another sheet and then get a TRUE/FALSE result in return. If that text (A1) is exist in the column D-sheet 2, column G-sheet 2(same row where A1 matched) will be evaluated such as a number, text or blank. If number or text, true and if blank false.

I try the following but the value for other text did not match.

=IF(AND(MATCH(A1, 'SHEET2'!D:D,0),OR(ISNUMBER(‘SHEET2’!G:G)=TRUE,'SHEET2'!G:G="Inc.")),"TRUE","FALSE")

Would anyone know how to do this? Please help me to find a way.
Thank you.