Re: $$Excel-Macros$$ vlookup return with pcture assinged

2011-10-23 Thread Vinod Rudalf
On 10/16/11, Sam Mathai Chacko wrote: > Since Noorain and Ashish aren't around, I'll step in. The main function used > is the INDIRECT function, along with a combo Match function to return the > position of the value being searched for. > > So for example, =INDIRECT("SourcePic!A"&MATCH($A$4,Source

Re: $$Excel-Macros$$ vlookup return with pcture assinged

2011-10-15 Thread prabhat.shrivasta...@gmail.com
Hi, can u pls explain the formula being used in this sheet. On Oct 14, 9:45 pm, NOORAIN ANSARI wrote: > Dear prabhat, > > Please find attached sheet in Excel 2003 Version. > Hope it help to u > > -- > Thanks & regards, > Noorain Ansari >  *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ vlookup return with pcture assinged

2011-10-14 Thread prabhat.shrivasta...@gmail.com
The file need to run on ms excel 2003 version. Rgrds.Prabhat On Oct 14, 12:03 pm, ashish koul wrote: > see if it helps > > On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com < > > > > > > prabhat.shrivasta...@gmail.com> wrote: > > Good morning experts > > > Need your valueab

Re: $$Excel-Macros$$ vlookup return with pcture assinged

2011-10-14 Thread NOORAIN ANSARI
Dear Prabhat, Please try it and see attached sheet for reference Copy it and paste in Formula-Define Name-Referes to Indirect Formula =INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com < prabhat.shri

$$Excel-Macros$$ vlookup return with pcture assinged

2011-10-13 Thread prabhat.shrivasta...@gmail.com
Good morning experts Need your valueable help to complete ma project, i have three n more pics in name of ram, shyam, n more pasted on diffrent sheet now i want if i write ram in a assinged cell ram's pic appear in selected area of sheet n so on. I dont wanna use macro for thisi need this