Not sure if question is "if-then".....
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! |
Not sure if question is "if-then".....
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! |
Not sure if question is "if-then".....
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! |
All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com