Matt,
Don't know the source of your data, but have you looked into Pivot Tables ?

NickHK

"Matt" ...
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)?