Lookup Returning Multiple Results

[joe1182]

In my Workbook I have a sheet called MASTER and it has the information
am wanting to extract.

In Cell AQ6 I have this "YHMIA.2615.1.400"

For each SKU# I have maybe 3 to 6 DIE's. I want to return the DIE #
DIE LOCATION, & DIE TYPE in a horizontal manor. Can this be done? An
help would be appreciated. Please see the example below for what I a
wanting.


AQ6 = "YHMIA.2615.1.400" This is SKU#
AR6 = "E" THIS IS DIE TYPE
AS6 = "8022" THIS IS DIE LOCATION
AT6 = "122" THIS IS DIE #

AU6 = "D" THIS IS THE SECOND DIE TYPE
AV6 = "8321" THIS DIE's LOCATION
AW6 = "122" THIS DIE's

 

[L. Howard Kittle]

Hi Joe,

With your Die numbers and Die info in A13, select three cells. With the
three cells still selected type in this formula. It will appear in the
active cell (white while the others are blue).

Now do an array enter... Crtl + Shift + Enter. You should get { } around
the formula in the formula bar and returns of three entries in cells you had
selected.

=VLOOKUP(F1,A13,{2,3,4},0)

If you want to change the formula after its been entered you will have to
select all three cells to make any changes and array enter again.

If some of you return info will be 6 items, then expand the formula as such
and select 6 cells before entering the formula. If a Die has only 2 or 4
items to return you will get a 0 in the non info cells.

=VLOOKUP(F1,A13,{2,3,4,5,6,7},0)

Of course change the reference cell and lookup array cells to suit your
sheet.

HTH
Regards,
Howard

 

[joe1182]

L. Howard Kittle,
Thank you for your response. However I think yo
misunderstood what I was wanting to do. The current thread is locate
here

http://www.excelforum.com/showthread.php?p=1472786&posted=1#post1472786

Sorry for the duplicate post

 

[L. Howard Kittle]

Hi Joe,

Send me an example workbook and some more explanation of what you want and I
will have a look at it.

Regards,
Howard

 

[joe1182]

I couldn't attach the sheet because it was to large. Can you send me an
e-mail address and I can forward you a zip file.

 

[joe1182]

I couldn't attach the sheet because it was to large. Can you send me a
e-mail address and I can forward you a zip file