need some conceptual guidance, advanced excel

[Guest]

Hi there,

I need to add a lookup function in a spreadsheet that grows every month with
new data. I'm trying to do one of the following, but keep getting stuck.

1) Create a VLOOKUP & SUMIF procedure that sums the values in a table which
meet 2 to 3 VLOOKUP conditions (i.e. the text/values in 2 or 3 of the
adjacent columns match - matching just one is not enough)

OR

2) Automate a process whereby a name can be defined for a specified range of
data based on an input cell (i.e., if my input cell was "February 2005", a
macro could create a name for a data range "February 2005")

Are either of these possible??

Thank you so much!!!!

Marika

 

[Tom Ogilvy]

=sumproduct(--(range1 = "a"),--(range2 = "b"),--(range3>2),--(range4=21))
does a count of rows that meet all conditions
=sumproduct(--(range1 = "a"),--(range2 =
"b"),--(range3>2),--(range4=21),range5)
sums up values in range5 where conditions specified are met

each rangeX is a single column area and each has the same number of rows or
it can be applied to a single row area with equal number of columns in each
but this usually isn't the paradigm of a database layout.


range("A1:B200").Name = Range("C1").Value

where C1 = "February_2005" without the quotes. Note that names can't
contain spaces.