hi,
does anyone have idea or solution to solve search over 2 columns range
where both criteria needs to be met.
e.g. if you have database with 3 columns. column A is account, column
B is cost centar and column C is value.
I would like to search for value of specific account for specific cost
center
send a sample sheet buddy
On Sun, May 9, 2010 at 12:07 AM, nino wrote:
> hi,
> does anyone have idea or solution to solve search over 2 columns range
> where both criteria needs to be met.
> e.g. if you have database with 3 columns. column A is account, column
> B is cost centar and column C is
You can concatenate Column A and Column B to get the unique value. Then do a
vlookup to get the exact value. Once performing this operation, you can
delete the concatenated column.
Hope this helps
Ta
Ravi
On Sun, May 9, 2010 at 12:04 PM, madhu nair wrote:
> send a sample sheet buddy
>
>
> On S
Hi nino,
check my reply in the $$Excel-Macros$$ Maximum Date problem.
Thanks & Regards
Sandeep
On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj wrote:
>
> You can concatenate Column A and Column B to get the unique value. Then do a
> vlookup to get the exact value. Once performing this operation,
use
vlookup ( match ,,,) funtion or sumproduct or array formula
On Mon, May 10, 2010 at 8:10 PM, Sandeep Kumar Maurya
wrote:
> Hi nino,
>
> check my reply in the $$Excel-Macros$$ Maximum Date problem.
>
> Thanks & Regards
> Sandeep
>
> On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj wrote:
>>
An INDEX & MATCH can also be done with two criteria. Just instead of
specifying one criteria for MATCH, you need to provide two criteria.
On 15 May 2010 19:42, manoj kukreja wrote:
> use
> vlookup ( match ,,,) funtion or sumproduct or array formula
>
>
>
>
> On Mon, May 10, 2010 at 8:10 PM, San
- Original Message
From: manoj kukreja
To: excel-macros@googlegroups.com
Sent: Sat, 15 May, 2010 7:42:40 PM
Subject: Re: $$Excel-Macros$$ vlookup with 2 criteria
use
vlookup ( match ,,,) funtion or sumproduct or array formula
On Mon, May 10, 2010 at 8:10 PM, Sandeep Kumar Maurya
Hi Srinivas,
Try the formula...and look attached sample...
*=SUMPRODUCT(($C$3:$C$5=G3)*($D$3:$D$5=H3)*($E$3:$E$5))*
On Tue, Aug 30, 2011 at 11:43 PM, Shrinivas Shevde
wrote:
> Dear all
> Can I use Vlookup with 2 criteria?
> If Yes please let me know
>
>
> --
> Shrini
>
> --
>
> --
You can use this :
=SUM((C3:C5=G3)*(D3:D5=H3)*(E3:E5))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 31, 2011 12:26 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup with 2 criteria
Hi
Subject: $$Excel-Macros$$ Vlookup with 2 criteria
Dear all
Can I use Vlookup with 2 criteria?
If Yes please let me know
--
Shrini
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Dear Shrinivas,
Please see attached sheet..
*=VLOOKUP(H6&I6,A4:D8,4,0)*
Alternative solutions...
*{=INDEX(D4:D8,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0))}
{=OFFSET(D3,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0),0)}*
*=DSUM(B3:D8,D3,H5:I6)*
--
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*
Dear All
Rally thanks for Kind help
Shrinivas
On Wed, Aug 31, 2011 at 9:20 PM, NOORAIN ANSARI wrote:
> Dear Shrinivas,
>
> Please see attached sheet..
>
> *=VLOOKUP(H6&I6,A4:D8,4,0)*
> Alternative solutions...
>
> *{=INDEX(D4:D8,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0))}
> {=OFFSET(D3,MATCH(1,(B4:B8=H6)*
12 matches
Mail list logo