We have a spreadsheet (see sample below) that we want to "match" Col1 with
Col4 and include Col2 and Col6. This is so that we can compare 2006 and 2007
pricing. Is their a formula for this? Hope you understand our request.

Thank you


Col1 Col2 Col3 Col4
Col5 Col6
COS010129 14.75 9.44 BDY0010White 3.975 7.95
COS010159 36.2 22.48 BDY0011Asst. 4.475 8.95
COS010160 45.85 28.07 BDY0012Yellow 3.975 7.95
COS010161 50.15 29.86 BDY0016White 3.975 7.95
COS010165 27.35 17.59 BDY0019Red 3.75 7.5
COS010170 15.75 10.28 BDY0020White 3.475 6.95
COS010173 61.35 39.5 BDY0031White 5.475 10.95
COS010174 38.3 23.93 BDY01146 7.375 14.75