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.

 

[lenze]

Have a look at VLOOKUP in the help files. When is your test?

lenze

 

[ELIAXEL]

My test is right now.

I'm not sure how to use vlookup.

 

[lenze]

My test is right now.

I'm not sure how to use vlookup.

That's sad!

lenze

 

[ELIAXEL]

Thanks for your help.

 

[jpowell79]

why can't you just copy/paste columns 2 & 3 ???

 

[ELIAXEL]

why can't you just copy/paste columns 2 & 3 ???

Because of duplicates in col1 of sheet1, I cannot simply copy and paste.

 

[NBVC]

In Sheet1, column 2 (Column B, row2)

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

In Column 3 (Column C, row2)

=Vlookup(A2,Sheet2!$A$1:$C$100,3,0) copied down

adjust ranges, references and sheet names to suit.

 

[ELIAXEL]

Thank you. I tried that but it didn't work for some reason. It keeps showing the "#REF" error message and I don't know why.

But I think we're on the right path.

 

[NBVC]

Is the sheet your referencing called Sheet2? If not change the name in the formula to match. Place the name between single quotes (e.g. 'The Sheet') and make sure the exclamation mark stays.

Also, make sure the index number (the 3rd argument) is the column number within the range that you want to extract from. If it is out of range, you'll get the REF error.

If you still have issues, post your formula and the exact locations of the info you want to manipulate in your workbook.