Keen searching until a value is found

I've got a sheet with 2 values 1 in column A and one in column B. I want to search through column A until I match a value in column B. I'm sure this is done using the .FindNext function.

Bit unclear so I'll illustrate with an example,

A B
5 S
6 F
7 R
5 Q
5 G
5 H
3 N
2 M

So I want to keep searching until I get a 5 in A and an H in B.

Also, if possible, how do I deal with a find error if nothing is found that match the criteria?

What's the best code for this?

Please Login or Register  to view this content.