Dear Ashish,
Try this one
=INDIRECT(ADDRESS((MATCH("*"&$B$3&"*",$B$9:$B$14,0)+8),3))
See attached sheet.
On Thu, Dec 29, 2011 at 6:51 PM, Ashish Bhalara
wrote:
> Dear Experts,
>
> I need to use vlookup function to look value by fulfill some particular
> condition. The example to understand the
Try this:
=INDEX($B$9:$C$14,MATCH("*"&B3,$B$9:$B$14,0),2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Dec/Fri/2011 01:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup value by fulfill som
Try this :
=OFFSET($B$9,MATCH("*"&B3,$B$9:$B$14,0),1,1,1)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Dec/Fri/2011 01:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup value by fulfill som
Try this:
=VLOOKUP("*828",$B$9:$C$14,2,0)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Dec/Fri/2011 01:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup value by fulfill some condition in li
One solution is attached.
Regards,
Aamir Shahzad
On Thu, Dec 29, 2011 at 6:21 PM, Ashish Bhalara
wrote:
> Dear Experts,
>
> I need to use vlookup function to look value by fulfill some particular
> condition. The example to understand the problem is attached herewith.
>
> Thanks & regards
>
> A
Dear Experts,
I need to use vlookup function to look value by fulfill some particular
condition. The example to understand the problem is attached herewith.
Thanks & regards
Ashish Bhalara
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
