Hi,

Pl do help me on this:

I have entered the names of places falling under category "X" in column A , category "Y" in column B and category "Z" in column C of sheet 1 in excel. Now in sheet 2 column B, I enter the name of a place. In the first cell of column C, I want to write a formula where in it should check if the place entered in sheet 2 column B falls under any of the categories X, Y, Z of sheet 1, and it should display X,Y, Z accordingly or it should display just "Others".

I need the formula for this so that if it is written in one cell it can be dragged down to all the cells of column C in sheet 2. Note that I am entering the names of places ie. they are texts and not numbers.

Looking forward to replies.