Related:
- Excel Query Urgent Please.
- Excel - Search & Display query - How-To - Excel
- Excel name match query ✓ - Forum - Excel
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- Transfer data from one excel worksheet to another automatically - How-To - Excel
- Show formula bar in excel - How-To - Excel
1 reply
tlynnec
- Posts
- 10
- Registration date
- Wednesday December 24, 2014
- Status
- Member
- Last seen
- January 13, 2015
vlookup would be my choice here. the catch is, in order for it to work, you need the names on sheet 1 to come before the numbers. is it possible to switch the orders of the columns on sheet 1 so that the names come first?
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Install a VPN
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- Facebook Code Not Received
The title is a little misleading as the VLOOKUP command is not used in the solutions given.
The very last example will work for this question though.
I too thought of using a pivot table but couldn't get it to format as required. How would you do it?
- Posts
-
3
- Registration date
- Tuesday January 13, 2015
- Status
- Member
- Last seen
- January 15, 2015
> tlynnecI tried with thi but i ahve an error - #VALUE!, Kindly advise
- Posts
-
3
- Registration date
- Tuesday January 13, 2015
- Status
- Member
- Last seen
- January 15, 2015
> tlynnecReturn MULTIPLE corresponding values for ONE Lookup Value, Horizontally, in one Row
=INDEX($B$2:$B$8, SMALL(IF($A$11=$A$2:$A$8, ROW($A$2:$A$8)-ROW($A$2)+1), COLUMN(A1)))
With the same example used in the website
Thanks in advance.