Excel help needed urgently

[ELIAXEL]

I have 2 different sheets

sheet 1:
4 different columns
Col1 - DealerID - this column is filled in and includes duplicates
Col2 - DealerName - this column is blank
Col3 - Province - this column is also blank
Col4 - Sales - this column is filled in

sheet 2:
3 different columns
Col1 - DealerID - filled in and no duplicates
Col2 - DealerName - filled in
Col3 - Province - filled in

What I need to do is use a formula to draw the info from sheet 2 onto the blank columns of sheet 1. Because of duplicates in col1 of sheet1, I cannot simply copy and paste. I am being tested on this and I need to find out ASAP.

Thanks for any help. If you need clarification, please let me know.

 

[ELIAXEL]

Yes it's properly named. Actually when I tried it with 1,0 at the end instead of 2,0, it worked but with the information I already have. It's strange with 2,0 it doesn't work, nor with 3,0.

crap

 

[NBVC]

That means your range is 2 dimensional (e.g. A1:A100), it should be 3 dimensional, e.g. A1:C100) covering 3 columns.

=Vlookup(A2,Sheet2!$A$1:$C$100,2,0)

 

[ELIAXEL]

OMG THAT'S IT!!!!

YOU'RE A FREAKING GOD!!! I LOVE YOU!

 

[NBVC]

Well now, I hope you pass your test :wink:

....and, of course, that you learned something

 

[ELIAXEL]

I have learned something. Actually I save all formulas I run across. I realize this was probably something very simple and I should've known it.

As for the test, it was job-interview related and I hope I didn't take too long. We'll see.

 

[ELIAXEL]

I got the job partner. I should buy you a drink some time.

 

[NBVC]

Are they hiring others....I don't live far from Toronto