 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2005Return range from row number
Hi I have a table from which I need to find specific values based on the rows they reside in. I need to search the (n)th row to return the column number where a specific number (x) is located. Top row of table is G29:CZ29 A1=value to match (x) from another worksheet A2=row to search (n) from another calculation Is there any way to achieve this by converting the known row and its endpoints into a "range" to be inserted in the MATCH function? MATCH(A1,"range",0) e.g. if A2=93, the "range" I need to search is G122:CZ122 Thanks in advance Andy One way: =MATCH(A1, OFFSET(G29:CZ29,A2,,1,)) > Hi > [quoted text clipped - 18 lines] > > Andy Hi Thanks for your quick response! Just tried it, but it always returns the value 1 for some reason! Andy > One way: > [quoted text clipped - 24 lines] >> >> Andy Try adding the exact match argument: =MATCH(A1, OFFSET(G29:CZ29,A2,,1,), FALSE) > Just tried it, but it always returns the value 1 for some reason! Sorry, I just figured it out - I entered the wrong references for the table! Works perfectly! Thanks a lot Andy > Try adding the exact match argument: > > =MATCH(A1, OFFSET(G29:CZ29,A2,,1,), FALSE) > >> Just tried it, but it always returns the value 1 for some reason! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.