That works! Couple questions...

1. What does "Set" do? i.e. What is the difference between "x = 3"
and "Set x = 3" ?
2. I'm trying to understand how the non-looping solution works (is
non-looping preferred?).
- if the 1st value in the A column is not the "value" we're looking
for then it finds the value and sets E to "V.End(xlUp)"?
- And what is "E.offset(-1)" for?

Thanks!