Hi
Look at the help for VLookup

=vlookup(A1, "$C$1:$E$300", 3, false)

will search the first column in "$C$1:$E$300" for the value in cell
A1. If it finds it, it will return the contents of the corresponding
column 3 entry. If A1 is not found you get an #N/A error. The false
bit means that "$C$1:$E$300" is not sorted.

regards
Paul

On Nov 5, 12:42*pm, James T Kirk <James T
wrote:
I am trying to compare a register of members with member-IDs to a list of
members who would like to close their membership but I haven't found a good
way to compare the value of one cell with the value of several cells (a
column) thereby checking if any value from cell A1 can be found in any of
cells B1 to B100 and the same for A2, A3 and so fourth.

Any suggestions?