How to make a cell read only

Hi!!

I want to maintain a record of scrips.Every scrip has its own code.For example A contains a name of Scrips & B contains Codes of Scrips.How its possible if i enter the new scrip name i save it some where with its code & if i re enter same name in A2 it will automatically display its code in B2 which is readonly.(Scrip names are more than 5000).


Thank You

I'm not exactly sure what you are asking, but you might consider using the
VLOOKUP formula.

Let's say your data is CURRENTLY in A1:B10
The following would be entered in B11

=IF(ISNA(VLOOKUP(A11,A$1:B10,2,FALSE)),"",VLOOKUP(A11,A$1:B10,2,FALSE))

If you get a blank, you don't have a value in the lookup table.



"Little Master" <Little.Master.1xnoyb_1130576701.878@excelforum-nospam.com>
wrote in message
news:Little.Master.1xnoyb_1130576701.878@excelforum-nospam.com...
>
> Hi!!
>
> I want to maintain a record of scrips.Every scrip has its own code.For
> example A contains a name of Scrips & B contains Codes of Scrips.How
> its possible if i enter the new scrip name i save it some where with
> its code & if i re enter same name in A2 it will automatically display
> its code in B2 which is readonly.(Scrip names are more than 5000).
>
>
> Thank You
>
>
> --
> Little Master
> ------------------------------------------------------------------------
> Little Master's Profile:
> http://www.excelforum.com/member.php...o&userid=28227
> View this thread: http://www.excelforum.com/showthread...hreadid=480325
>