Wow! I didn't detect that difference. Thought they were identical and the
only difference was the direction of the list entry.

Thanks,
Alan

"Alan Beban" wrote in message
...
KL wrote:
Ian,

Just select 3 cells horizontally, copy the formula . . .
Which formula? I gave two. One with commas, one with semicolons. One
returns a vertical array, the other returns a horizontal array (which is
which depends on whether you use comma or semicolon as your normal
delimiter).

Alan Beban

into the first one and press Ctrl+Shift+Enter. Entering the same formula
vertically does not for me either, but this does:

=TRANSPOSE(VLOOKUP(3,A1:G8,{2;5;6}))

again, select 3 cells vertically, enter the formula in the first cell and
Ctrl+Shift+Enter.

Regards,
KL



"Ian Johnson" wrote in message
...

Alan thanks for your reply, however I'm struggling to make
the function work. I follow the logic and it looks like
what I want to do ie: fill three continuous cells in a row
from the VLOOKUP funtion. I've tried pasting your example
in a blank cell and I get the value from column B, but I
can't seem to get the values in columns E & F. Presumably
I need to copy the VLOOKUP function in the first cell into
the next two cells but I'm not sure how to get this right,
the range reference increments as I copy it and making the
reference absolute just gets me the same value as the
first cell of the row.

Ian.

-----Original Message-----
Ian Johnson wrote:

Does the VLookUp function only allow you to return the
value in ONE column from the "column_index_number" in

the

functions arguements?
. . .

No.

=VLOOKUP(3,A1:G8,{2,5,6}), array entered into a 3-cell

row will return

the values from Columns B,E & F that correspond to the

value of 3 in

Column A.

=VLOOKUP(3,A1:G8,{2;5;6}) will return them to a 3-cell

column.

Alan Beban
.