How to make a cell read only

  • Thread starter Thread starter Little Master
  • Start date Start date
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
 
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]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with IF 2
work with IF 3
Index match formula works in for one worksheet reference but not another 2
Creating column content based on another column's keyword(s) 1
Can I make a Common Array Class and create a instance of the Common Array Class with Type of a new c 10
nse website query 2
cells beginning with an alphabet 2
Drop-down list and error message 1

Back
Top