| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning the desired value if multiple values exist????
Hi......big question he
please look at this chart: SHEET1 SHEET2 Shape | Color Shape | Color ------------------------ ------------------------- box blue box blue box red box red box pink box pink circle blue cirlcle blue circle green circle green circle pink circle aquamarine circle red circle red SHEET3 Shape | Color --------------------------- circle pink so, I want to verify that the contents in Sheet1 are the same as Sheet 2....if not, I want to record the changes in sheet3 (only show the changes). How do I search Sheet2 for pink circle? What function would I use? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning the desired value if multiple values exist????
sorry about the previous post.... .here is a cleaned up version of
the table. A big concern of mine is: What if a row is added on the next run....like another box is added, will this mess things up? SHEET1 SHEET2 Shape | Color Shape | Color ------------------------ ------------------------- box blue box blue box red box red box pink box pink circle blue cirlcle blue circle green circle green circle pink circle aquamarine circle red circle red SHEET3 Shape | Color --------------------------- circle pink njuneardave wrote: Hi......big question he please look at this chart: SHEET1 SHEET2 Shape | Color Shape | Color ------------------------ ------------------------- box blue box blue box red box red box pink box pink circle blue cirlcle blue circle green circle green circle pink circle aquamarine circle red circle red SHEET3 Shape | Color --------------------------- circle pink so, I want to verify that the contents in Sheet1 are the same as Sheet 2....if not, I want to record the changes in sheet3 (only show the changes). How do I search Sheet2 for pink circle? What function would I use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning multiple corresponding values using lookup in a list | Excel Discussion (Misc queries) | |||
| lookup multiple values | Excel Worksheet Functions | |||
| vlookup returning multiple values | Excel Worksheet Functions | |||
| Multiple Cell Values, please help | Excel Discussion (Misc queries) | |||
| Multiple X-Axis Values | Charts and Charting in Excel | |||
Linear Mode
