Using vlookup and if/then statements for multiple tables

Richard, your code worked perfectly except for one thing: if the element is NOT listed in the table, it gives me a "#N/A" and I'd prefer for it to say "Not NTS" as well, but other than that, it works wonderful. Thank you so much.

Also, b/c I am not familiar with index/match, I wanted to see why the vlookup isn't working. So MarvinP, I tried changing the table I used to 'ElementTable', but it still isn't working right. What else am I doing wrong???