| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: Return rownumber when text data on 3 columns match exa
Using: Excel 2007
I want to document Windows Group Policy settings side by side on a single sheet. To accomplish this task I want to return the row number of the current sheet where the data of the row that has an exact match. The data I want to lookup is in three colums. Example: Column B | Column C | Column D ------------------------------------------------------------------------------------------- Policy | Control Panel | Load a specific visual style Policy | Desktop | Do not add shares Policy | Desktop | Hide Network Locations icon Policy | Desktop | Prohibit User from manually redirecting Policy | Desktop | Remove the Desktop Cleanup Wizard What I want to query: I want the row number to be returned where I've got an exact match on a single row within the active worksheet. Example: Give me the row number where "Column B = Policy" and "Column C = Desktop" and "Column D = Do not add shares". I do make a remark that the columns are NOT sorted. My Question: How can I query this information from a active worksheet and return the row number where the match is found. I hope you can help me Thx in advance. Greetings Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
| Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
| Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
| Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha | Excel Discussion (Misc queries) | |||
| Can I use Excel to match text data from 2 separate columns ? | Excel Worksheet Functions | |||
Threaded Mode
