I don't know what this function would be called (which is probably why I
haven't already found an answer!).

I use a template for purchase orders and I would like to be able to choose
the size/dimensions (Column C) of the piece we are ordering first and THEN
have the item number fill in (Column A) once the size is ordered. This is how
I am given the part to order - by size/dimension only, never by item number.

I have the sizes/dimensions in a validation list currently but I am using
copy/paste to fill in the item number.

I tried to make a validation list with the catalog number in 1 column and
the size/dimensions in the column next to it but it messes up my formatting
that way.

This is basically how the PO format is laid out:

Column A Column B Column C
Item# Item Size/Dimension
(i.e. OSG404-0312-BN11 Drill Bit 1/32 4FLSE REG CARB BALL-TiAIN)

Any suggestions? I hope this makes sense to everyone out there.

Thanks!

Use match to find the row and index to find the column where c4 is your
validation cell

=INDEX(b7:c10,MATCH(C4,C7:C10),1)

--
Don Guillett
SalesAid Software

"Shan" wrote in message
...
I don't know what this function would be called (which is probably why I
haven't already found an answer!).

I use a template for purchase orders and I would like to be able to choose
the size/dimensions (Column C) of the piece we are ordering first and THEN
have the item number fill in (Column A) once the size is ordered. This is
how
I am given the part to order - by size/dimension only, never by item
number.

I have the sizes/dimensions in a validation list currently but I am using
copy/paste to fill in the item number.

I tried to make a validation list with the catalog number in 1 column and
the size/dimensions in the column next to it but it messes up my
formatting
that way.

This is basically how the PO format is laid out:

Column A Column B Column C
Item# Item Size/Dimension
(i.e. OSG404-0312-BN11 Drill Bit 1/32 4FLSE REG CARB
BALL-TiAIN)

Any suggestions? I hope this makes sense to everyone out there.

Thanks!

Hi Don,

Thanks for posting a solution.

It is working as far as pulling from the correct list but it is not
returning the correct item # adjacent to the size/dimension chosen in the
drop down list. I am sure it is something silly on my end. Could you take
another look and tell me what I am doing wrong? Here are the specifics of my
spreadsheet and the formula I entered:

My validation lists are off to the side of the actual printable area:

Item # list is in cells L28:L68.
Size/dimension list is in cells N28:N68

In the actual PO section, I choose the size/dimension from a drop down in
cell H27.
I want the item # to populate in cell C27 once the size/dimension is chosen.
(it is pulling from the item # list, just not the correct ones).

Based on that, this is the formula I entered in cell C27:

=INDEX(L28:L68,MATCH(H27,N28:N68),1)

Thanks once again for your help.

"Don Guillett" wrote:

Use match to find the row and index to find the column where c4 is your
validation cell

=INDEX(b7:c10,MATCH(C4,C7:C10),1)

--
Don Guillett
SalesAid Software

"Shan" wrote in message
...
I don't know what this function would be called (which is probably why I
haven't already found an answer!).

I use a template for purchase orders and I would like to be able to choose
the size/dimensions (Column C) of the piece we are ordering first and THEN
have the item number fill in (Column A) once the size is ordered. This is
how
I am given the part to order - by size/dimension only, never by item
number.

I have the sizes/dimensions in a validation list currently but I am using
copy/paste to fill in the item number.

I tried to make a validation list with the catalog number in 1 column and
the size/dimensions in the column next to it but it messes up my
formatting
that way.

This is basically how the PO format is laid out:

Column A Column B Column C
Item# Item Size/Dimension
(i.e. OSG404-0312-BN11 Drill Bit 1/32 4FLSE REG CARB
BALL-TiAIN)

Any suggestions? I hope this makes sense to everyone out there.

Thanks!

Looks like it should work. You may send a SMALL workbook to my private email
below for a look see

--
Don Guillett
SalesAid Software

"Shan" wrote in message
...
Hi Don,

Thanks for posting a solution.

It is working as far as pulling from the correct list but it is not
returning the correct item # adjacent to the size/dimension chosen in the
drop down list. I am sure it is something silly on my end. Could you take
another look and tell me what I am doing wrong? Here are the specifics of
my
spreadsheet and the formula I entered:

My validation lists are off to the side of the actual printable area:

Item # list is in cells L28:L68.
Size/dimension list is in cells N28:N68

In the actual PO section, I choose the size/dimension from a drop down in
cell H27.
I want the item # to populate in cell C27 once the size/dimension is
chosen.
(it is pulling from the item # list, just not the correct ones).

Based on that, this is the formula I entered in cell C27:

=INDEX(L28:L68,MATCH(H27,N28:N68),1)

Thanks once again for your help.

"Don Guillett" wrote:

Use match to find the row and index to find the column where c4 is your
validation cell

=INDEX(b7:c10,MATCH(C4,C7:C10),1)

--
Don Guillett
SalesAid Software

"Shan" wrote in message
...
I don't know what this function would be called (which is probably why
I
haven't already found an answer!).

I use a template for purchase orders and I would like to be able to
choose
the size/dimensions (Column C) of the piece we are ordering first and
THEN
have the item number fill in (Column A) once the size is ordered. This
is
how
I am given the part to order - by size/dimension only, never by item
number.

I have the sizes/dimensions in a validation list currently but I am
using
copy/paste to fill in the item number.

I tried to make a validation list with the catalog number in 1 column
and
the size/dimensions in the column next to it but it messes up my
formatting
that way.

This is basically how the PO format is laid out:

Column A Column B Column C
Item# Item
Size/Dimension
(i.e. OSG404-0312-BN11 Drill Bit 1/32 4FLSE REG CARB
BALL-TiAIN)

Any suggestions? I hope this makes sense to everyone out there.

Thanks!