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
|
|||
|
|||
Data validation
Can I use data validation to populate 2 cells.
I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#2
|
|||
|
|||
Data validation
You need to use VLOOKUP.. Please find the below example
Suppose you have data in Col A and Col B ColA ColB 1 One 2 Two 3 Three C1 = Product Code (example 2) In D1 enter the below formula ;should return the text "Two" =VLOOKUP(C1,$A$1:$B$10,2) If this post helps click Yes --------------- Jacob Skaria "dragons_lair" wrote: Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#3
|
|||
|
|||
Data validation
I believe that can happen...
You will have to list the product codes in one column and the desired descriptions in the next column. Can be anywhere on the sheet and even on a different sheet. So with Product Codes in column D110 and descriptions in E1:E10... Then in the cell you want the returned result you would enter a formula like... =VLOOKUP(A1,D1:E10,2,0) Where A1 is the lookup_value. HTH Regards, Howard "dragons_lair" wrote in message ... Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#4
|
|||
|
|||
Data validation
Alternatively if you are looking at conditional lookup refer the below link
http://www.contextures.com/xlDataVal13.html -- If this post helps click Yes --------------- Jacob Skaria "dragons_lair" wrote: Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#5
|
|||
|
|||
Data validation
Thanks so much saved me hours of heartache, works like a charm. Just another
dumb question for you what is the 2,0 on the end of the formula for? -- Dragonette "L. Howard Kittle" wrote: I believe that can happen... You will have to list the product codes in one column and the desired descriptions in the next column. Can be anywhere on the sheet and even on a different sheet. So with Product Codes in column D110 and descriptions in E1:E10... Then in the cell you want the returned result you would enter a formula like... =VLOOKUP(A1,D1:E10,2,0) Where A1 is the lookup_value. HTH Regards, Howard "dragons_lair" wrote in message ... Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#6
|
|||
|
|||
Data validation
Thanks so much, saved me lots of heartache and I got it to work.
-- Dragonette "Jacob Skaria" wrote: Alternatively if you are looking at conditional lookup refer the below link http://www.contextures.com/xlDataVal13.html -- If this post helps click Yes --------------- Jacob Skaria "dragons_lair" wrote: Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#7
|
|||
|
|||
Data validation
2nd column of the data range.. If your data range has got 10 columns and you
want to return the 8th column info, specify that as 8 -- If this post helps click Yes --------------- Jacob Skaria "dragons_lair" wrote: Thanks so much saved me hours of heartache, works like a charm. Just another dumb question for you what is the 2,0 on the end of the formula for? -- Dragonette "L. Howard Kittle" wrote: I believe that can happen... You will have to list the product codes in one column and the desired descriptions in the next column. Can be anywhere on the sheet and even on a different sheet. So with Product Codes in column D110 and descriptions in E1:E10... Then in the cell you want the returned result you would enter a formula like... =VLOOKUP(A1,D1:E10,2,0) Where A1 is the lookup_value. HTH Regards, Howard "dragons_lair" wrote in message ... Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#8
|
|||
|
|||
Data validation
As Jacob said, the 2 is the column to return. The fourth argument 0 asks
for an exact match. You can use FALSE or 0. If you omit the fourth argument OR use 1 or TRUE, then if there is no match the formula will return the nearest match that is less than the lookup value. HTH Regards, Howard "dragons_lair" wrote in message ... Thanks so much saved me hours of heartache, works like a charm. Just another dumb question for you what is the 2,0 on the end of the formula for? -- Dragonette "L. Howard Kittle" wrote: I believe that can happen... You will have to list the product codes in one column and the desired descriptions in the next column. Can be anywhere on the sheet and even on a different sheet. So with Product Codes in column D110 and descriptions in E1:E10... Then in the cell you want the returned result you would enter a formula like... =VLOOKUP(A1,D1:E10,2,0) Where A1 is the lookup_value. HTH Regards, Howard "dragons_lair" wrote in message ... Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
#9
|
|||
|
|||
Data validation
Thanks for all the info much appreciated and solved my problems
-- Dragonette "L. Howard Kittle" wrote: As Jacob said, the 2 is the column to return. The fourth argument 0 asks for an exact match. You can use FALSE or 0. If you omit the fourth argument OR use 1 or TRUE, then if there is no match the formula will return the nearest match that is less than the lookup value. HTH Regards, Howard "dragons_lair" wrote in message ... Thanks so much saved me hours of heartache, works like a charm. Just another dumb question for you what is the 2,0 on the end of the formula for? -- Dragonette "L. Howard Kittle" wrote: I believe that can happen... You will have to list the product codes in one column and the desired descriptions in the next column. Can be anywhere on the sheet and even on a different sheet. So with Product Codes in column D110 and descriptions in E1:E10... Then in the cell you want the returned result you would enter a formula like... =VLOOKUP(A1,D1:E10,2,0) Where A1 is the lookup_value. HTH Regards, Howard "dragons_lair" wrote in message ... Can I use data validation to populate 2 cells. I select the product code from list and it fills out the product description in correspondening cell as well. -- Dragonette |
Thread Tools | |
Display Modes | |
|
|