vlook/Match/index

N

nowfal

I have 2 sheets in my work book, In the first sheet i have a colom
which is newly made for customer ID. In the second sheet I have a lis
of customer ID with details of the customer in the continous colomn. M
problem is if i put the id number in the first sheet i have to get th
details of the particular customer in the next two three cells. It i
like as follows
First sheet:
A B C D E F
DATE IDNO NAME PPT NO TEL POBOX


Second sheet:

A B C D E
IDNO NAME PPT TEL POBOX

Is it possible to give any formula for this purpose.
thanks in advance.
NOWFA
 
F

Frank Kabel

Hi
in cell B2 on your second sheet try
=VLOOKUP($A2,'sheet1'!$B$1:$E$100,COLUMN(A:A)+1,0)
and copy down/to the right
 
Top