Return range from row number

A

Andy Sandford

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
 
A

Andy Sandford

Hi

Thanks for your quick response!

Just tried it, but it always returns the value 1 for some reason!

Andy
 
J

JE McGimpsey

Try adding the exact match argument:

=MATCH(A1, OFFSET(G29:CZ29,A2,,1,), FALSE)
 
A

Andy Sandford

Sorry, I just figured it out - I entered the wrong references for the table!

Works perfectly!

Thanks a lot

Andy
 
Top