Looking for information in a list

  • Thread starter Thread starter c5883
  • Start date Start date
C

c5883

I've been scratchin' my head over the following problem.
I have data that looksl Like
(Worked)
BOB CUSTOMER
James Customer 2

Then I have another area of data that looks like
(Assignments)
James D
BOB C

I want to look at my (Worked Data) and If the First coum is any one in
the (Assignments) Data then the field should be the second colum for
the assigments

Examle
Look in (WORKED) MATCHES ANYTHING LISTED in ASSIGNMENTS list the colum
next to assignemnts

Life example
IF(A1:A2 Matchs anything in Assignemtns(A1:A2) Then display
Asignemnts(Colum next to name)

Another example that does not work :-D
=IF(WORKED!A:A=OR(ASSIGNEMNTS!A:A),Display the Colum B for (Assignemnts
of that name), "No listed")

Perhaps of thoes who know loops.

FOR NAME_WORKED in WORKED ; do
FOR ASSIGNED_LIST in ASSIGNED ; do
IF NAMED_WORKED = ASSGINED_LIST than display B2
else
nothing
done
done

I hope that makes sence.
 
Back
Top