IF, VLOOKUP & DATA VALIDATION TOGETHER

[Guest]

TRYING TO PUT IT (IF THE MANUFACTURER IS A (FROM A DATA VALIDATION LIST),
THEN THE PRODUCT CAN ONLY BE CHOSEN FROM A LIST FROM COMPANY A'S WORKSHEET -
I'M CONFUSING MYSELF BUT I KNOW YOU GUYS KNOW.


MAIN PAGE
A B
2 MANUFACTURER /COMPANY PRODUCT
3 DATA VALIDATION LIST OF COMPANYS (DROP DOWN MENU CREATED FROM
COMPANY A'S WORKSHEET LIST OF PRODUCTS)
4 COMPANY B ("" FROM
COMPANY B'S LIST OF PRODUCTS)

COMPANY A
PRODUCT A
PRODUCT B
PRODUCT C

 

[Pete_UK]

Please don't SHOUT !!

I think what you want is dependent data validation - Debra Dalgleish
shows how here:

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

Hope this helps.

Pete

 

[Guest]

sorry about hte caps.
I'm trying to say in Column F that if Column E says Company 1 - then use
dropdown menu in F from that Company 1s worksheet