I have this problem...

D

dalipsinghbisht

What should i do when i have to work in an Excel File and there are man
Account no in Sheet 1 and Sheet 2 contains many account no and ther
Date now i have to take Account no. from sheet 1 one by one and come t
the Sheet 2 to search there availability and paste there Date in Shee
1.

i.e.

sheet 1 contains a column
Coulmn A
Account No.
0004317575603512196
0004006676010767385
0004317575603323636
0004317575603277113
0004317575603539660.

Sheet 2

Coulmn A
Account No.
0004317575603631103
0004317575603578569
0004317575603097701
0004317575603512196
0004006661130015717
0004006676010767385
0004317575603548794
0004317575603323636
0004006661030774793
0004317575603277113
0004317575603539660

Sheet 2

Coulmn B
Date
01/30/06
01/30/06
01/30/06
01/30/06
01/27/06
01/30/06
01/05/06
01/31/06
01/18/06




Is there any way that we can paste all 5 Account No's Date to the fron
of Account Nos in Sheet 1


Note: i use =vlookup(A2,sheet2!a2:b8439,2,0) but it is not workin
properly cuz it is not taking all the dates in sheet 1.

Thanks in advanc
 
W

wdjsxj

VLOOKUP(A17,sheet2!$A$2:$B$10,2) can do the job

“dalipsinghbishtâ€ç¼–写：
 
J

Jerry W. Lewis

If Topper's answer was not helpful, then your question is not clear. Instead
of reposting the same question, reply back in your earlier thread explaining
why the proposed answer was inadequate.

Jerry
 
Top