Hi Friends, I am having an excel sheet with a list of technical course and their respective course fees. On the sheet 2 a have a search column where whenever i type the course name it gives the fees according to the technical course name but whenever i make a mistake in typing the course name it gives me different course fees. There are basically two problems
a) if i make a mistake in typing the name the a different feee is shown Secondly,
b) If in the sheet 2 search column is blank the columns show #N/A.
Please help me to get rid of these problems.
Bookmarks