need some conceptual guidance, advanced excel

[marika1981]

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.

--
Regards,
Tom Ogilvy


"marika1981" <marika1981@discussions.microsoft.com> wrote in message
news:985B6DA1-B774-4864-99CB-21DC91669B96@microsoft.com...
> 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
>
>