Function in a cell to search for a text

Originally Posted by Lilly

I entered the codes and also typed the formula in the cell but am getting an error "Name" in the cell

Actually where should I enter the codes after opening the excel sheet?

Let me be more specific by giving you the details:

1) In sheet 1, I have the following data for eg:

Metropolis Urban Semi-Urban

Delhi Hyderabad Adilabad
Mumbai Vijayawada Kagaznagar
Kolkata Vishakapatnam Nirmal
Chennai Guntur Bellampalle
Guwahati Mandamarri
Patna Mancherial
Chandigarh Nizamabad
Durg-Bhilai Bodhan
Nagar Kamareddy
Raipur Ramagundam
Ahmadabad Jagtial

The category names is given in the first row.ie Metropolis,etc.

Now in sheet 2 column D cell 2 i will enter the name of the place. In column K , I want this formula such that the place entered in cell 2 of Column D sheet 2 will be categorised into either Metro, Urban, semiurban and if the place does not fall in any of these categories it should display "rural"

Pl do tell me specifically what I should do. Thanks a lot for all the effort once again. Looking forward to your help.

Lilly

Following formula is implemented in attached workbook

=IF(NOT(ISERROR(MATCH(C5,Sheet1!B:B,0))),"Metro",IF(NOT(ISERROR(MATCH(C5,Sheet1!C:C,0))),"Urban",IF(NOT(ISERROR(MATCH(C5,Sheet1!D:D,0))),"Semi Urban","Rural")))