Need to fill a cell based on two conditions.
Compare a cell in worksheet A to column A in worksheet B, if found: compare
cell in worksheet B to row A, if found, populate orignal row and column (from
second compare) from cell xx (worksheet b).
IE: A2 (worksheet a) finds entry in column A, based on condition 1, C1
(worksheet b) finds entry in B1 (worksheet a) populate B2 (worksheet A) with
B2 (worksheet b).

ORIGNAL WORKSHEETS RESULTING
WORKSHEETS
worksheet a: worksheet b: workheet A:
A B C d A B C
A B C
1 iel01 iel02 iel03 igc019 5 iel01
iel01 iel02 iel03
2 igc019 igc019 2 iel03 igc019
5 2
3 uareit uareit 1 iel02 uareit
1
4 thatsit thatsit 1 iel01
thatsit 1 2 2
5 thatsit 2 iel02
6 thatsit 2 iel03


Thanks for any help you can provide.