# Transposing V Lookup Results

#### Vmeista

##### New Member
Hi Guys.

How do i display Vlook up results horizontally?

It has to be a vlook up and not a Hlook up. I can copy and transpose the data but this is time consuming.

E.G 5,8,7,5

A B
Index Data
1 5
2 8
3 7
4 5

Ive tried this to no avail: =VLOOKUP(A2,A1:B6,2,FALSE) Also
=VLOOKUP(\$A2,A1:B6,2,FALSE)

The required result would read

C1 C2 C3 C4
5 8 7 5

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
With your datarange from A1 to B4, put this formula into C1 and copy to the right...=VLOOKUP(INDIRECT("A"&COLUMN()-2),\$A\$1:\$B\$4,2,0)

GREAT THANK YOU !!!!!

Hi vmeista:

Welcome to MrExcel Board!

In addition to the contribution from Indiatrix, you may also use the following array formula for cells D1:G1

=TRANSPOSE(VLOOKUP(A1:A4,A1:B4,2))

as in the following illustration ...
Book1
ABCDEFG
1155875
228
337
445
Sheet2

Hi, Vmeistra (Yogi, 2!)
You are welcome. Glad to help whenever possible. Larry

Replies
12
Views
655
Replies
5
Views
461
Replies
2
Views
341
Replies
5
Views
486
Replies
2
Views
172

1,221,199
Messages
6,158,488
Members
451,496
Latest member
pledge8236

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back