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