Vlookup i think.............

[Aide]

Hi All

Newbie here looking for some help please.

I'm working on a spread sheet where I need the information from multiple columns in one spread sheet (Component Costs) and return them to a master worksheet (Master), however it only returns the first row.

The components worksheet as around 31K rows and 10 columns, however I only need the information from 4 only these columns.

Here is the formula I have used, =VLOOKUP(B4,'Component Cost'!A2:J31011,6,FALSE) for each column and I've attached images of worksheets to help.

Thanks
Aide