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

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

First of all, don't post using only capital letters - no need to
SHOUT !!

Put this formula in C1:

=VLOOKUP(D1,A:B,2,0)

assuming the name you enter is in D1.

Hope this helps.

Pete

On Aug 25, 11:36*am, 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

Hi,

Typing in capitals makes it very difficult to read and is considered to be
SHOUTING. Please kill the caps.

Try this in C1 and drag down as required

=IF(D1<"",VLOOKUP(D1,A1:B1000,2,FALSE),"")

Mike

"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