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:
thanks this was what i needed.
Taking it forward if it is in sheet 1 then can it pick up a value in
anotther column of the same row like how we use in V LOOK UP
instead of YES or NO
S Baloo
On 8/23/10, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
If the question really is is it in
Yes, but it gets complicated. Have a look at the attached. If the
Village/district combination is not found, then we get a #NA error. We can add
more formula to remove it if needed.
Regards - Dave.
Date: Mon, 23 Aug 2010 16:00:29 +0530
Subject: Re: $$Excel-Macros$$ V look up more than one
it if needed.
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 it forward if it is in sheet 1 then can