C
chilitodd
For my vlook up in excel 2007, I want to return data to populate cell B2
(xxxx) from column 3 ($21,745) of a data set when the value in cell A2 (360
19318) AND B1 (200801) match from the original data set.
DATA SET
1 2 3
Dosfrom OP_Combined Claimed_Avg
200801 360 19318 $21,745
200803 360 19318 $22,462
200805 360 19318 $25,527
200806 360 19318 $22,462
A B c D
1 Row Labels 200801 200802 200803
2 360 19318 xxxx
3 360 47562
4 480 93620
(xxxx) from column 3 ($21,745) of a data set when the value in cell A2 (360
19318) AND B1 (200801) match from the original data set.
DATA SET
1 2 3
Dosfrom OP_Combined Claimed_Avg
200801 360 19318 $21,745
200803 360 19318 $22,462
200805 360 19318 $25,527
200806 360 19318 $22,462
A B c D
1 Row Labels 200801 200802 200803
2 360 19318 xxxx
3 360 47562
4 480 93620