VLOOKUP to return from multiple columns from another workbook

[Poolshark25]

Hi

Does anyone know how i can return multiple column using VLOOKUP in a new workbook?

I have tried this off the net but it won't work.

=VLOOKUP(A3,[Parks and Leisure Sites.xlsx]Sheet1'!$A:$F,{2,3,4,5},FALSE)

Thanks

Ernie

 

[Joe4]

Typically, you would have four VLOOKUP functions, one to return each column.