excel IF formula

[shib]

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

 

[Jacob Skaria]

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

 

[Pete_UK]

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

 

[Mike H]

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