Dear Anil,
Sorry for late reply.
Two options which you can use:-
1) As suggested earlier, you can use lookup function OR,
2) If you do not want to use formula to be already housed in the result
area, then you can use worksheet_change event to enter same formula.
Best Regards,
--
DILIP KUMAR PAND
Hi Anil,
You can vlookup function. Please see the attached file for your
information.
Regards,
R. SHIVAKUMAR
On Thu, Nov 19, 2009 at 10:28 AM, Anil Saxena wrote:
> Hi All
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value.
>
>
>
>A
Hi Anil,
>From Insert menu goto Define Names (As you do for named ranges) then give
the Each name (Anil) the value you want.
Then
A B
1Anil =indirect(A1)
2Saxena =Indirect(A2)
Regards
Sandeep
On Thu, Nov 1
I hope this will help
On Thu, Nov 19, 2009 at 12:59 PM, Dave Bonallack
wrote:
> Hi Anil,
> Do you want the value in the same cell as the one you write the name in?
> If so, do you want the value to replace the name? (ie, "Anil" automatically
> changes to "100")
> Or do you want the value a
Hi Anil,
Do you want the value in the same cell as the one you write the name in?
If so, do you want the value to replace the name? (ie, "Anil" automatically
changes to "100")
Or do you want the value added to the name? (ie, "Anil" automatically becomes
"Anil 100")
Regards - Dave.
Date: