lookup 2 variables
 

Hi,

I have a rather large spreadsheet which I am using to populate another based
on vlookups. On this occasion, I wish to look up an ID and a date from the
large spreadsheet (the ID is in column A and may repeat, the date is in
column C, and again may repeat, but together with the ID, there should only
be 1 occurrance of the combination) and return a value from another column
(Employment Status). Both the large spreadsheet and the spreadsheet I wish
to populate are ongoing documents and will increase in length.

Any ideas would be gratefully received.

Many thanks,

Karen

lookup 2 variables
 

Hi Karen,

try to use something like:

=sumproduct(--(a2:a1000="yourid")*(c2:c1000=date(2006,08,28));(d 2:d1000)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"KarenF" escreveu:

Hi,

I have a rather large spreadsheet which I am using to populate another based
on vlookups. On this occasion, I wish to look up an ID and a date from the
large spreadsheet (the ID is in column A and may repeat, the date is in
column C, and again may repeat, but together with the ID, there should only
be 1 occurrance of the combination) and return a value from another column
(Employment Status). Both the large spreadsheet and the spreadsheet I wish
to populate are ongoing documents and will increase in length.

Any ideas would be gratefully received.

Many thanks,

Karen