| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding information from two rows - formula or macro?
I have been trying to find the answer to this question but think maybe Im
asking the wrong things. I have two rows of data, one with company names and one where if a company is awarded there will be a tick (or yes) or whatever. Im looking for a formula that will look at the second row, and if there is a tick then it will give me the company name from above. in a cell on another workbook This seems like such an easy thing to do but Im struggling with it. Many thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding information from two rows - formula or macro?
What should happen if more than one company has a "tick"?
-- Rick (MVP - Excel) "rsmith" wrote in message ... I have been trying to find the answer to this question but think maybe Im asking the wrong things. I have two rows of data, one with company names and one where if a company is awarded there will be a tick (or yes) or whatever. Im looking for a formula that will look at the second row, and if there is a tick then it will give me the company name from above. in a cell on another workbook This seems like such an easy thing to do but Im struggling with it. Many thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding information from two rows - formula or macro?
Hi Rick
There will only be one company with a tick as it is a selection processw and only one company will be awarded. Thanks Rachael "Rick Rothstein" wrote: What should happen if more than one company has a "tick"? -- Rick (MVP - Excel) "rsmith" wrote in message ... I have been trying to find the answer to this question but think maybe Im asking the wrong things. I have two rows of data, one with company names and one where if a company is awarded there will be a tick (or yes) or whatever. Im looking for a formula that will look at the second row, and if there is a tick then it will give me the company name from above. in a cell on another workbook This seems like such an easy thing to do but Im struggling with it. Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Macro - Finding rows with data to copy | Excel Worksheet Functions | |||
| Finding Duplicate Rows (Macro) | Excel Discussion (Misc queries) | |||
| Macro formula for counting rows | Excel Programming | |||
| Macro Formula for counting rows and doing a fill in afterwards | Excel Worksheet Functions | |||
| finding # of occurrences of information between two dates | Excel Worksheet Functions | |||
Linear Mode
