C
chief
cell C19 = product code drop down list
cells N1:O449 = description of prod associated w/ dropdown list
cell E19 = product description column
cell I19 = price column
cell P1:Q449 = list associated with product code drop down list
Right now there is this code in cell E19:
IF(C19<>""(C19,$N$1:$O$449,2,0),"")
This code allows me to pick a code # from the drop down list in C1
(which is referenced to column N and O) and once selected, th
corresponding product will appear in the product description cel
(E19). I now am trying to set up a code in cell I19 so that once tha
specific product code OR description (whichever is easier to use
reference) is selected it will put the corresponding price into cel
I19. This way the user can click on a product code and have the prope
name and price be input into the appropriate cells, thus saving time.
I tried to play around with the code and i put it into cell I19, bu
once i click the product code drop down button and select a code #, th
product description is fine, but the associated price comes up as #N/A
any ideas as to what can be done?
here was my code modification for the price cell
IF(C19<>""(C19,$P$1:$Q$449,2,0),"") i also tried playing with the 2,
at the end but had no luck. what does that 2,0 at the end reference t
anyways?
thanks to Frank for helping me out earlier with those code
cells N1:O449 = description of prod associated w/ dropdown list
cell E19 = product description column
cell I19 = price column
cell P1:Q449 = list associated with product code drop down list
Right now there is this code in cell E19:
IF(C19<>""(C19,$N$1:$O$449,2,0),"")
This code allows me to pick a code # from the drop down list in C1
(which is referenced to column N and O) and once selected, th
corresponding product will appear in the product description cel
(E19). I now am trying to set up a code in cell I19 so that once tha
specific product code OR description (whichever is easier to use
reference) is selected it will put the corresponding price into cel
I19. This way the user can click on a product code and have the prope
name and price be input into the appropriate cells, thus saving time.
I tried to play around with the code and i put it into cell I19, bu
once i click the product code drop down button and select a code #, th
product description is fine, but the associated price comes up as #N/A
any ideas as to what can be done?
here was my code modification for the price cell
IF(C19<>""(C19,$P$1:$Q$449,2,0),"") i also tried playing with the 2,
at the end but had no luck. what does that 2,0 at the end reference t
anyways?
thanks to Frank for helping me out earlier with those code