View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fonebone Fonebone is offline
external usenet poster
 
Posts: 1
Default 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