Data Not Available

%3CLINGO-SUB%20id%3D%22lingo-sub-2151022%22%20slang%3D%22en-US%22%3EData%20Not%20Available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151022%22%20slang%3D%22en-US%22%3E%3CP%3EPurchase%20Order%20form%20has%207%20worksheets%20in%20a%20workbook.%20Column%20C%20is%20the%20name%20of%20the%20vendor%20(pull-down).%26nbsp%3B%20Column%20D%20are%20the%20parts%20that%20are%20available%20to%20purchase%20from%20each%20vendor%20(pull-down).%20I%20have%2027%20vendors.%26nbsp%3B%20When%20I%20select%20any%20one%20vendor%20in%20Column%20C%2C%20I%20can%20choose%20what%20part%20I%20want%20to%20order%20from%20this%20vendor%20from%20Column%20D.%26nbsp%3B%20But%2C%20I%20have%20two%20vendors%20that%20when%20they%20are%20selected%20from%20Column%20C%2C%20no%20parts%20are%20shown%20in%20Column%20D%20to%20choose.%20A%20worksheet%20called%20Item%20Description%20has%20over%20800%20parts%2C%20each%20with%20their%20individual%20price.%26nbsp%3B%20A%20worksheet%20called%20Lists%20is%20the%20list%20of%20all%20vendors%20in%20alphabetical%20order.%26nbsp%3B%20All%20names%20are%20spelled%20correctly%20on%20all%20worksheets.%20Column%20D%20uses%20a%20%22%3Dindirect%22%20formula.%26nbsp%3B%20When%20I%20select%20the%20vendor%20that%20does%20not%20show%20me%20available%20items%20for%20sale%20and%20I%20open%20up%20the%20Direct%20Validation%20window%2C%20I%20get%20an%20error%20that%20says%20that%20the%20%22source%20currently%20evaluates%20to%20an%20error.%22%26nbsp%3B%20But%20Excel%20does%20not%20say%20what%20the%20error%20is.%26nbsp%3B%20I%20checked%20the%20spelling%20of%20both%20of%20these%20vendors%20on%20all%20worksheets%2C%20the%20spelling%20is%20the%20same%20throughout%20the%20workbook.%20Why%20don't%20I%20see%20what%20items%20these%20two%20vendors%20have%20to%20sell%3F%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2151022%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2151356%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Not%20Available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151356%22%20slang%3D%22en-US%22%3EIf%20possible%20please%20edit%20your%20post%20%26amp%3B%20share%20the%20WB%20wit%20us%2C%2C%2C%20and%20let%20me%20check%20the%20issue%20to%20fix%2C%2C%2C%20meanwhile%20I%20would%20like%20ask%2C%2C%2C%20does%20the%20method%20is%20set%20to%20select%20one%20Vendor%20at%20a%20time%20for%20one%20part%20or%20multiple%20vendor%20for%20one%20part%20!!%3C%2FLINGO-BODY%3E
New Contributor

Purchase Order form has 7 worksheets in a workbook. Column C is the name of the vendor (pull-down).  Column D are the parts that are available to purchase from each vendor (pull-down). I have 27 vendors.  When I select any one vendor in Column C, I can choose what part I want to order from this vendor from Column D.  But, I have two vendors that when they are selected from Column C, no parts are shown in Column D to choose. A worksheet called Item Description has over 800 parts, each with their individual price.  A worksheet called Lists is the list of all vendors in alphabetical order.  All names are spelled correctly on all worksheets. Column D uses a "=indirect" formula.  When I select the vendor that does not show me available items for sale and I open up the Direct Validation window, I get an error that says that the "source currently evaluates to an error."  But Excel does not say what the error is.  I checked the spelling of both of these vendors on all worksheets, the spelling is the same throughout the workbook. Why don't I see what items these two vendors have to sell?    

1 Reply
If possible please edit your post & share the WB wit us,,, and let me check the issue to fix,,, meanwhile I would like ask,,, does the method is set to select one Vendor at a time for one part or multiple vendor for one part !!