I'm trying to use an IF statement for referencing a cell's text value within a data range and if there is a match, then go to another cell and display its value, if not then "No Match"

As an example: Cell R6 contains the text "AA06", the range of data I want to see if "AA06" is present is from E13:M24, if it is present, I want to display a specific cell as the true value and if not "No Match"

Here is the IF statement I can get to work on a single cell reference:
=IF(R6=D13,D14,"No Match")

Here is one that give me a #value! error
=IF(R7=E13:M24,E17,"NO TX")

Any help is very appreciated.