If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autofill data based on an assigned code/prefix
I am an estimator, and I am trying to make a new template that will allow me
to enter a "smart part number" in column "A" that will find the corresponding material description from column "K" and re-insert the description in to column "B"...An alternative for this is to be able to start typing the beginning of the description in "B" and it auto fill based on the long format in "K".... |
#2
|
|||
|
|||
Autofill data based on an assigned code/prefix
Do you have a part number in a column to correspond with column K?
Column J perhaps? If so, then you can use this in say B2: =IF(A2="","",IF(ISNA(MATCH(A2,J:J,0)),"not valid",INDEX(K:K,MATCH(A2,J:J,0)))) If your part numbers are not in column J, then change the references to suit. I have used INDEX/MATCH rather than VLOOKUP in case your column of part numbers is on the other side of column K - the formula will still be valid. You will get a blank returned if A2 is blank, and a "not valid" message if the part number in A2 is not recognised. Copy the formula down as required. Hope this helps. Pete On Feb 11, 5:44*pm, anrcreations wrote: I am an estimator, and I am trying to make a new template that will allow me to enter a "smart part number" in column "A" that will find the corresponding material description from column "K" and re-insert the description in to column "B"...An alternative for this is to be able to start typing the beginning of the description in "B" and it auto fill based on the long format in "K".... |
#3
|
|||
|
|||
Autofill data based on an assigned code/prefix
Check out the VLOOKUP function.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "anrcreations" wrote: I am an estimator, and I am trying to make a new template that will allow me to enter a "smart part number" in column "A" that will find the corresponding material description from column "K" and re-insert the description in to column "B"...An alternative for this is to be able to start typing the beginning of the description in "B" and it auto fill based on the long format in "K".... |
Thread Tools | |
Display Modes | |
|
|