In cell C1
enter a name which is in ColA

In cell D1
=IF(ISNA(VLOOKUP(C1,A:B,2,0)),"Not found",VLOOKUP(C1,A:B,2,0))

If this post helps click Yes
---------------
Jacob Skaria


"shib" wrote:

I AM WORKING IN AN EXCEL SPREAD SHEET WHICH CONSISTS OF
TWO COLUMNS. ONE IS DEDUCTEE NAME AND ANOTHER IS PAN NO. OF THE PARTICULAR
DEDUCTEE.

I WANT TO PUT A FORMULA IN COLUMN NO.3.

MEANS IF I WRITE ANY DEDUCTEE NAME FROM COLUMN NO.1 IN COLUMN NO.4 ,THE
PAN NO. OF THAT PARTICULAR DEDUCTEE AUTOMATICALLY APPEAR IN THE COLUMN NO.3