If a cell matches a range on another worksheet -- display value of cell in next column

try:

Formula:

=iferror(index(Sheet1!$F$2:$F$4478,MATCH(A14,Sheet1!$E$2:$E$4478,0)),"Not Available")

or

Formula:

=iferror(VLOOKUP(A14,Sheet1!$E$2:$F$4478,2,FALSE),"Not Available")