Your post and question are still not clear.

Your request:

HTML Code: 
E2 on List2 is Material and there is nbo matching column on sheet1.
There is no "row A". Did you mean column A?.
You want to compare five values from List2 with what five values/text on list1?

Give a specific example with result. Enter the expected result manually and describe the logic to get that result.

I am sure it's clear in your mind, what you want, but we can't read your mind, so you need to help us understand.

modytrane.