How to do a search in a few colums

I need to do a search so that I do not put double entries in a sheet, I have to go true 30-40 pages A day and have to put it in excel.

So I need to do a search on 3 columns to see if the entry is already in or not.

Is this possible and how can I do it.

The best method which i think is using VBA. If you attach a sample file by explaining the method then it will be helpful to us to proceed further...

Oops misunderstood

30-40 pages

as sheets, so no need to go for VBA, it can be done using worksheet functions itself.

Insert a helper column after Column E and use Column-F as helper column.

In F2 cell

Formula:

Please Login or Register  to view this content.

Drag it down

Whenever a new entry occurs in B,C & E columns then the formula applied in the current row intimate you whether the entry is already available or not.

Please explain why we have to look every sheet since there is no relevancy of data in each each sheets columns.

Refer the attached file for details. I have applied the formula for 200 row of column F. So whenever you do an entry in the respective columns then the formula will compare it with the previous entries and show the result.

Still not sure what is your expectation, so if the above suggestion doesn't helps then please explain your expectation a bit more...