Hi,
I have something of the following :
Sheet 1
(Name Range : Code)
Column A -------- Column B
School ------------ 1
College ----------- 2
University--------- 3
Sheet 2
Cell A1 = (Search for "College" in Name Range Code and get the Value of "2" as code. ) So value of 2 should be present in Cell A1.
Please provide excel VBA