In my Workbook I have a sheet called MASTER and it has the information I
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? Any
help would be appreciated. Please see the example below for what I am
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 #


--
joe1182
------------------------------------------------------------------------
joe1182's Profile: http://www.excelforum.com/member.php...o&userid=30977
View this thread: http://www.excelforum.com/showthread...hreadid=506454

Hi Joe,

With your Die numbers and Die info in A1:D3, 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,A1:D3,{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,A1:D3,{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" wrote in
message ...

In my Workbook I have a sheet called MASTER and it has the information I
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? Any
help would be appreciated. Please see the example below for what I am
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 #


--
joe1182
------------------------------------------------------------------------
joe1182's Profile:
http://www.excelforum.com/member.php...o&userid=30977
View this thread: http://www.excelforum.com/showthread...hreadid=506454

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

http://www.excelforum.com/showthread...=1#post1472786

Sorry for the duplicate post.


--
joe1182
------------------------------------------------------------------------
joe1182's Profile: http://www.excelforum.com/member.php...o&userid=30977
View this thread: http://www.excelforum.com/showthread...hreadid=506454

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" wrote in
message ...

In my Workbook I have a sheet called MASTER and it has the information I
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? Any
help would be appreciated. Please see the example below for what I am
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 #


--
joe1182
------------------------------------------------------------------------
joe1182's Profile:
http://www.excelforum.com/member.php...o&userid=30977
View this thread: http://www.excelforum.com/showthread...hreadid=506454

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
------------------------------------------------------------------------
joe1182's Profile: http://www.excelforum.com/member.php...o&userid=30977
View this thread: http://www.excelforum.com/showthread...hreadid=506454

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
------------------------------------------------------------------------
joe1182's Profile: http://www.excelforum.com/member.php...o&userid=30977
View this thread: http://www.excelforum.com/showthread...hreadid=506454