I have a table that has 3 columns: location (A), shift (B) and headcount (C).
I have another table that has location and shift columns by work day rows. I
want to return the headcount value from the 1st table into the location
column of the 2nd table based upon the location column and shift row values
for that day. I tried:

=IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B 4),(VLOOKUP(B4,B21:C42,2)))

and got a return from the 2nd column instead of the 3rd. €œTrace Precedents€�
shows that only the A and B columns are €œseen.€� Using VLOOKUP got the same
results.

Is what Im trying to do possible? How?

Thanks in advance for any help on this.
Bob