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

2011-10-23 Thread Vinod Rudalf
On 10/16/11, Sam Mathai Chacko samde...@gmail.com 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,

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 noorain.ans...@gmail.com wrote: Dear prabhat, Please find attached sheet in Excel 2003 Version. Hope it help to u -- Thanks regards, Noorain Ansari  

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

2011-10-14 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

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!BMATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.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 koul.ash...@gmail.com 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