Vlookup using array of column numbers

[Mohsin110]

I am trying to get values using vlookup by array of columns but it does not find all values,

=VLOOKUP($B$3,Freight2025!B2:F,{4,5},0)

It returns only the value of 4th column and the value of column No 5, 6 so on, is not returning.
but if I enter the number of one column (like No. 5 column only) the value returns correctly.

=VLOOKUP($B$3,Freight2025!B2:F,5,0)

Please help.

The table is below

 

[alansidman]

Look at this tutorial on how to achieve with Xlookup

 

[Sam_D_Ben]

May be something like this,

=XLOOKUP($B3, Freight2025!$B$2:$B$7, INDEX(Freight2025!C$2:$F$7, , {1,2}))

 

[Fluff]

Is this for Excel or Google Sheets?

 

[kvsrinivasamurthy]

Try

=VLOOKUP($B$3,Freight2025!B2:F100,4,0)&","&=VLOOKUP($B$3,Freight2025!B2:F100,5,0)

 

[kvsrinivasamurthy]

Try.

=index(Freight2025!E2:E100&","&Freight2025!F2:F100,Match($B$3,Freight2025!B2:B100,0))