Merging Two Sheets - VLookup?

[pt_lily]

I have two Sheets. They both contain customer lists. One sheet contains the
customer number and sales amounts. The other sheet contains the customer
number and address information. I need to combine them so that I have one
sheet that shows address information and sales amounts for each customer
number. The customer numbers will not be in the same rows in each sheet, so
I need for the formula to search and say "if the customer # on sheet 2 = the
customer # on sheet one, then pull the address information from that row".
Can this be done with a VLookup?

Sheet One:
Customer Number: Column D
Sales Amount: Column E

Sheet Two:
Customer Number: Column B
Address Information: Column E

Thanks!

 

[Nayab]

I have two Sheets.  They both contain customer lists.  One sheet contains the
customer number and sales amounts.  The other sheet contains the customer
number and address information.  I need to combine them so that I have one
sheet that shows address information and sales amounts for each customer
number.  The customer numbers will not be in the same rows in each sheet, so
I need for the formula to search and say "if the customer # on sheet 2 = the
customer # on sheet one, then pull the address information from that row"..  
Can this be done with a VLookup?

Sheet One:
Customer Number:  Column D
Sales Amount:  Column E

Sheet Two:
Customer Number:  Column B
Address Information:  Column E

Thanks!

Yes, it is possible!! (Gee that sounds like I just invented it...but
no, it was there for long)

well in the sheet two lets put the following in a new column (lets say
F)
=VLOOKUP(B1,Sheet1!$D:$E,2,0)