Vlookup to auto-fill multiple columns based off 1 column

[forestavekids]

Hi all.

Trying to get a vlookup function to work.

I have a column labeled SKU, COLOR, SIZE, SOUND.

I would like to use a vlookup function, but unsure how since the columns are not next to each other. I need the vlookup to always reference the SKU column as it is the only one with a fixed value.

Please see attached.

[OzTrekker]

Is this what you are after?

Please Login or Register  to view this content.

[LeoTaxi]

For H3

Please Login or Register  to view this content.

For I3

Please Login or Register  to view this content.

Cheers
Leo

[LeoTaxi]

@ OzTrekker

you have size in color

[forestavekids]

What if the g3 is on sheet 1 and the data columns on sheet 2? cant get it to work with that.

[OzTrekker]

For H3

Please Login or Register  to view this content.

For I3

Please Login or Register  to view this content.

[forestavekids]

Better example..

[LeoTaxi]

Looks like same exemple

[OzTrekker]

I agree LeoTaxi.

[sanram]

You can use INDEX/MATCH also :
On H3 :

Please Login or Register  to view this content.

On I3 :

Please Login or Register  to view this content.

Say the name of your sheet 2 is Sheet 2, Then use like this :
'Sheet 2'!$A$3:$A$5
'Sheet 2'!$C$3:$C$5
'Sheet 2'!$D$3:$D$5

If the name of your sheet 2 is Sheet2, Then like this :
Sheet2!$A$3:$A$5
Sheet2!$C$3:$C$5
Sheet2!$D$3:$D$5

i.e. If your sheet name contain any space then you need to use (') at the start and end of the name, else (') is not needed.

Hope that help.