How to make a cell read only

L

Little Master

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
 
B

Barb Reinhardt

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" <[email protected]>
wrote in message
news:[email protected]...
 
Top