I am trying to write a formula using the ISNA for finding the name to an ID.
In Sheet 1 cell E2, I tried the following
formula...=IF(D20,INDEX(Sheet2!A:F,MATCH('Sheet1' !D2,Sheet2!A:A,0),6),"")

On Sheet 2 the ID is in column A but I need the name of the ID that is found
in column F. If the ID in column D on Sheet1 is blank, I want the name on
Sheet 1 to be blank. If the ID in column D on SHeet 1 is not found in column
A on Sheet 2, then I want the result to be "Invalid ID"

Thank you.