Multiple Searchable Drop Lists - problem - macro using offset to create list for dropdown menu won't show all menu items in data validation -
(not sure how to upload my worksheet to this site - please advise)
this is the 'active cell' where you enter the search string and the offset macro should return the DV list
DV List=SWRN.VNDR.LKUP
this is the formula that creates the list from the VNDR.SEARCH codes in col. A
=IFERROR(VLOOKUP(ROWS($G$6:G6),$A$6:$B$854,2,FALSE),"")
this is the NamedRange formula that creates the dropdown menu
SWRN.VNDR.LKUP =@OFFSET($G$6,0,0,COUNTIF($G$6:$G$854,"?*"),1)
EXAMPLE: when you enter "able" in C2 (the active cell with data validation), the menu dropdown list is created BUT then menu button in C2 doesn't work.
(not sure how to upload my worksheet to this site - please advise)
this is the 'active cell' where you enter the search string and the offset macro should return the DV list
DV List=SWRN.VNDR.LKUP
this is the formula that creates the list from the VNDR.SEARCH codes in col. A
=IFERROR(VLOOKUP(ROWS($G$6:G6),$A$6:$B$854,2,FALSE),"")
this is the NamedRange formula that creates the dropdown menu
SWRN.VNDR.LKUP =@OFFSET($G$6,0,0,COUNTIF($G$6:$G$854,"?*"),1)
EXAMPLE: when you enter "able" in C2 (the active cell with data validation), the menu dropdown list is created BUT then menu button in C2 doesn't work.