Regards - Dave.
>
> --
> Date: Mon, 23 Aug 2010 16:00:29 +0530
> Subject: Re: $$Excel-Macros$$ V look up more than one criteria
>
> From: sba...@gmail.com
> To: excel-macros@googlegroups.com
>
> thanks this was what i needed.
>
> Taking i
Bonallack wrote:
Hi,
If the question really is "is it in sheet 1"? then this is a job for SUMPRODUCT!
Please see the attached to see if it helps.
Regards - Dave.
Date: Mon, 23 Aug 2010 06:28:14 +0530
Subject: $$Excel-Macros$$ V look up more than one criteria
From: sba...@gmail.
t in sheet 1"? then this is a job for
> SUMPRODUCT!
> Please see the attached to see if it helps.
> Regards - Dave.
>
> --
> Date: Mon, 23 Aug 2010 06:28:14 +0530
> Subject: $$Excel-Macros$$ V look up more than one criteria
> From: sba...@gmail
Hi,
If the question really is "is it in sheet 1"? then this is a job for SUMPRODUCT!
Please see the attached to see if it helps.
Regards - Dave.
Date: Mon, 23 Aug 2010 06:28:14 +0530
Subject: $$Excel-Macros$$ V look up more than one criteria
From: sba...@gmail.com
To: ex
I have two sheets as follows
Sheet one
Vilagedist state
Sheet 2
Villagedist is it in sheet one
= Vlookup() in sheet one first col,1,false
Obviously the village in sheet 2 is not the same as
