wrap formula to allow cell to stay blank instead of showing #N/A

What is the proper way to wrap this formula so that if there is a blank in a cell in column A in the DATA worksheet, that instead of showing #N/A the cell will just be blank?

=INDEX(TABLES!$B$2:$B$8,MATCH(A2,TABLES!$A$2:$A$8,0))

Sample attached

Put this in A2 and copy down.

=IF(A2="","",INDEX(TABLES!$B$2:$B$8,MATCH(A2,TABLES!$A$2:$A$8,0)))

How about

Formula:

Please Login or Register  to view this content.

This works! Thank you both!!!

Glad to help & thanks for the feedback.