Pulling "Matrix" Data
Thank you Tom!
"Tom Ogilvy" wrote:
Assume M1 holds the string "Region1"
M2 holds the string "code 2"
further assume the Region Name is in the Sales column in each case
Match(M1,A1:G1,0) give the column for region 1
Match(M1,A1:G1,0)+1 gives the Revenue column for Region 1
Match(M2,A1:A100,0) gives the row for code 2
Put those in the index function
=Index(A1:G100,Match(M2,A1:A100,0),Match(M1,A1:G1, 0)+1)
gives the revenue for the appropriate code.
--
Regards,
Tom Ogilvy
"Matt" wrote:
I am trying to return information using look-ups by looking up info that is
in a column and a row....so
Region 1 Region 2 Region 3
Sales Revenue Sales Revenue Sales Revenue
Code 1
Code 2
Code 3
So, say I want the revenue for Code 1 and Region 1 returned in a
report....I'm just not sure of the syntax....do I create a name reference and
do a look-up from that? Something like lookup(Code1|Region1,Cell
References,2,False)?
|