Dear All Experts and friends,
Thank you so much
regards
M.S.Girish
On 20 March 2013 21:48, >>Excel Beginner<< wrote:
> Hi Girish,
>
> Try
> this
> =LOOKUP(2,SEARCH(G$4,$A$4:$A$15185)*SEARCH($F5,$B$4:$B$15185),$C$4:$C$15185)
>
> On Wed, Mar 20, 2013 at 10:48 AM, M S GIRISH wrote:
>
Hi Girish,
Try
this
=LOOKUP(2,SEARCH(G$4,$A$4:$A$15185)*SEARCH($F5,$B$4:$B$15185),$C$4:$C$15185)
On Wed, Mar 20, 2013 at 10:48 AM, M S GIRISH wrote:
>
> Thank you anil
>
> It is working on the first column when it drag to another column it is
> shows erroor and Instead of "N/A" it sh
Thank you anil
It is working on the first column when it drag to another column it is
shows erroor and Instead of "N/A" it should take the previous date closing
price.
Please help.
regards
GIRISH
On 20 March 2013 09:00, अनिल नारायण गवली wrote:
> Dear G.Rishi,
>
> Pl see the attached sheet.
Hi Girish,
Use this
=IF(VLOOKUP(G$4,$A$4:$B$15185,2,0)=$F5,VLOOKUP(G$4,$A$4:$C$15185,3,0),"") in
cell G5 and copy down and right.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of M S GIRISH
Sent: Tuesday, March 19, 2013 10:55 PM
To:
