This formula appears to be pulling against a list for both conditions...It's
not working. Check out my example below. It may help to put what I have
written into word or excel so you can see it all at one time. Sorry... but I
am struggling with this formula
Sheet 1
A B C D E
Client Ctrl# Population AL # of Empl
Advantage 10871 12000 (if F) (unknow F)
AmeriCredit 10872 3700 (if F) (unknow F)
Andrew Corp 39514 2666 (if F) (unknow F)
Asurion 11087 4200 (if F) (unknow F)
A T Kearney Inc 19083 659 (if F) (unknow F)
Sheet 2 (Data table dumped from Access)
A B C
State Client CountOfParticipant SSN
AL HP 100
AR HP 200
CA HP 700
AL Asurion 300
AR Asurion 10
CA Kmart 102
TX Walmart 109
I am looking for something that says, where Sheet 1 A3 and D2 match with
A:A, B:B from Sheet 2, return value column C
Repeat in next line A4 and D2
and so on through the grid