Transposing V Lookup Results

Vmeista

New Member
Joined
Jul 29, 2007
Messages
2
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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

indiantrix

Well-known Member
Joined
Oct 17, 2002
Messages
943
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)
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
 

indiantrix

Well-known Member
Joined
Oct 17, 2002
Messages
943
Hi, Vmeistra (Yogi, 2!)
You are welcome. Glad to help whenever possible. Larry
 

Forum statistics

Threads
1,181,647
Messages
5,931,210
Members
436,784
Latest member
amuljono

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?

Disable AdBlock

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
Top