Data validation

[dragons_lair]

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.

 

[Jacob Skaria]

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]

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

 

[L. Howard Kittle]

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

 

[L. Howard Kittle]

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

 

[Jacob Skaria]

Alternatively if you are looking at conditional lookup refer the below link

http://www.contextures.com/xlDataVal13.html

 

[Jacob Skaria]

Alternatively if you are looking at conditional lookup refer the below link

http://www.contextures.com/xlDataVal13.html

 

[dragons_lair]

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?

 

[dragons_lair]

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?

 

[dragons_lair]

Thanks so much, saved me lots of heartache and I got it to work.

 

[dragons_lair]

Thanks so much, saved me lots of heartache and I got it to work.

 

[Jacob Skaria]

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

 

[Jacob Skaria]

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

 

[L. Howard Kittle]

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

 

[L. Howard Kittle]

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]

Thanks for all the info much appreciated and solved my problems

 

[dragons_lair]

Thanks for all the info much appreciated and solved my problems