vlook/Match/index

  • Thread starter Thread starter nowfal
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlook/match/index 12
Returning multiple values 2
To Max MVP 7
LOOKUP 1
Two colums match return text from another 12
Setting up macro betwen two sheets 1
find and copy it.. 2
need help with merging 2 sheets 1

Back
Top