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