R

#### RWD715

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)=B4),(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 Iâ€™m trying to do possible? How?

Thanks in advance for any help on this.

Bob