excel IF formula

  • Thread starter Thread starter shib
  • Start date Start date
S

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
 
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
 
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
 
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
 
Back
Top