LOOKUP value and return multiple values

[rfcapinto]

Hi all,

I have a excel file with 2 worksheets sample.xlsx

I have a worksheet with stocks and other with sales, my goal is to lookup the the REF and return the sales to the stock worksheet


I've been trying to experiment with vlookup but I only managed to retrieve 1 value every time,
My goal would be to return a few cells with one lookup.

Is that possible, please help.

Thanks
Best regards,

[NeedForExcel]

Put this in B6 of the Stock sheet

=IFERROR(VLOOKUP($A6,Tabela1,MATCH(B$4,Tabela1[#Headers],0),0),"")

Drag Down & Across..

please see the file attached..

[JohnTopley]

In D6

=VLOOKUP($B6,Tabela1[[DESC]:[TOTAL]],COLUMN()-2,0)

and copy across

[rfcapinto]

Put this in B6 of the Stock sheet

=IFERROR(VLOOKUP($A6,Tabela1,MATCH(B$4,Tabela1[#Headers],0),0),"")

Drag Down & Across..

please see the file attached..

In D6

=VLOOKUP($B6,Tabela1[[DESC]:[TOTAL]],COLUMN()-2,0)

and copy across

Thanks both for the fast response.

Solved!

Thanks.

[NeedForExcel]

Glad it helped!