IF, VLOOKUP & DATA VALIDATION TOGETHER

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top