vb code question

[Stan]

That's perfect Dave. Many thanks!

I do have another question. The function
=If(Iserror(Match(A1,$B$1:$B$6,0)),"",A1) works perfect although I would like
to also return the value in column C. In other words, if there is a match
for column B to Column A then I would like to copy and paste the value from
Column C from the row where columns A and B match.

Can the Offset function be used?

Any help you can provide
would be greatly appreciated!!

 

[Dave Peterson]

=Offset() could be used, but =index() (non-volatile) makes more sense here.