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

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

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 D1:D10 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

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

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 D1:D10 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

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

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 D1:D10 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

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 D1:D10 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

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 D1:D10 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