Oh, nutz <g! The problems of being adept in one programming language, and
then jumping into another. I have a nice little book called VB & VBA in a
nutshell. I need to find something on one worksheet based on a search
criterion from another.

Sooooo I go to the index -- seems reasonable thing to do. I look for FIND,
SEEK, LOCATE, LOOKUP, SEARCH. None of these words except SEEK appear in the
index, and SEEK isn't what I need. Phooey <g!!!

So haere's what I'm trying to do:

Worksheet A has columns A, B, and C respectively containing SSN, Last name,
First Name.

Worksheet B has column P containing Last name & ", " & First name in it.

Both worksheets have name data in all upper case.

I want to scroll through Column P of Worksheet B, grab a name, pop over to
worksheet A, find the lastname, firstsheet pair that matches, grab the SSN
from column A and take it back to Worksheet B and drop it into Column Q.

Worksheet A is sorted on First name & Last name.

Have I given enough info for someone to be able to give me a clue on how to
proceed?
--
Dave
Temping with Staffmark
in Rock Hill, SC