Excel Spreadsheet Assistance (Match, Compare)
 

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

Excel Spreadsheet Assistance (Match, Compare)
 

Well, your example is a bit small, and doesn't include any matches, but try
this:

In column 7 (which I will assume is column G), use a formula like this in
row 2's cell (G2):

=VLOOKUP(A2,$D:$F,3,False)

and copy down to match your table. This formula will return the value from
column F of the same row from where the value in column D matches the value
in the current row's cell in column A. If your columns are not A through F,
adjust the addresses appropriately.

HTH,
Bernie
MS Excel MVP


"Nancy" wrote in message
...
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