Thread
:
Not sure if question is "if-then".....
View Single Post
#
2
Don Guillett
Posts: n/a
Not sure if question is "if-then".....
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!
Reply With Quote