| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Excel Workbooks | Excel Discussion (Misc queries) | |||
| Import excel spreadsheet into an excel spreadsheet | Excel Worksheet Functions | |||
| Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
| Excel Spreadsheet Not Saved Dialog Error | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Threaded Mode
