MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 268|Reply: 1

Lookup more than 1 item and show its data across

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 2-12-2017 02:18:05 | All posts |Read mode
I basically need to be able to do a vlookup but not just for the first value that can be returned.
Currently i have thousands of lines of data like :
Have :
Item#Order
390V0RDR231 Qty 3520 Jan 12
X02M0RFD3522 Qty 5972 Oct 24
X02M0RDR231 Qty 3520 Jan 12
390V0JKDS450X Qty 5982 Nov 2
404PK3RDR231 Qty 34 Jan 12
X02M0OIRC396ZZ Qty 12 Dec 2
404PK3RFD3522 Qty 86 Oct 24
Need :
Item#Order 1Order 2Order 3
X02M0RFD3522 Qty 5972 Oct 24RDR231 Qty 3520 Jan 12OIRC396ZZ Qty 12 Dec 2
390V0RDR231 Qty 3520 Jan 12JKDS450X Qty 5982 Nov 2
404PK3RDR231 Qty 34 Jan 12RFD3522 Qty 86 Oct 24

Orders are maximum maybe 15 so i can paste a formula across and drag it down if needed. If i need to use a VBA formula its okay but i do not know how to create code.
Thanks much




Reply

Props Report

19

Topics

1896

Posts

4035

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4035
Post on 2-12-2017 03:22:42 | All posts



Hi, welcome to the forum
Whar are you basing your search/lookup on, I cannot tell
You would probably need something like INDEX/SMALL/IF ARRAY formula
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-21-2017 14:34 , Processed in 0.192086 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!