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,
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
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
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
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