vlookup

[Curious]

Hi Folks;
I have a sheet "A" that has a column called premium code, and then I have another sheet "B" that has the premium code column as well as 3 other columns. I would like to do a vlookup and when ever the premium code from the sheet "A" matches the premium code on sheet "B" to copy the other 3 columns from sheet "B" to sheet "A".

Thanks

 

[NBVC]

In the first row on Sheet A next to the Code, enter these

To return the first column,
=Vlookup($A1,SheetB!A:D,2,0)

For the second column,
=Vlookup($A1,SheetB!A:D,3,0)

For the third column
=Vlookup($A1,SheetB!A:D,4,0)

Copy these down as far as needed.

 

[Curious]

Thanks I think that is exactly what I am looking for.

ray: ray: ray:

 

[Aladin Akyurek]

Hi Folks;
I have a sheet "A" that has a column called premium code, and then I have another sheet "B" that has the premium code column as well as 3 other columns. I would like to do a vlookup and when ever the premium code from the sheet "A" matches the premium code on sheet "B" to copy the other 3 columns from sheet "B" to sheet "A".

Thanks

In B2 on sheetA enter & copy down:

=MATCH(A2,sheetB!A:A,0)

where A2 houses a premium code to match.

In C2 enter and copy across to E2 then down:

=IF(ISNUMBER($B2),INDEX(sheetB!B:B,$B2),"")

 

[NBVC]

I don't see how 2 formulas (one having 2 functions) is better than having the Vlookup formulas, which need only change the column number to reference.