how to extend formula

[Cyko]

i am trying to extend my database on a drop down menu. as you can see in the pics. the drop down menu stops at st03-05( example 2) . but the database tab ( example 1) goes past that.

 

[awoohaw]

how is your lookup drop down list defined? is it a named ranged?
(compare the list range cell references with the cell references in the actual list)?

"e" is not in the list because it is part of the defined LIST
(A6 is not part of the list)

 

[Cyko]

fyi, the database is on a different tab. but there are 949 lines on it.

 

[Cyko]

first 3 show the check in / out drop menu. 4th and 5th show that inventory for that drop down menu.

 

[awoohaw]

I dont understand.

do you have an array formula in cell Q9:Q1577?
Or is it in a table?

In another part of your workbook, enter a formula that creates an array of your unique values in Q9:Q1577.
Assume you put this list starting in cell Z2. Then in the List dialog of the data validation enter Z2#

 

[Cyko]

i don't know much about the spread sheet on how it was made. i had someone on etsy make it for me. but they stopped responding . i tried adding info to Column O, row 11 and the drop down menu came up blank.

 

[awoohaw]

wow. why don't you post the workbook to a share drive. Your images don't help me help you.

 

[Cyko]

wow. why don't you post the workbook to a share drive. Your images don't help me help you.

toolroom tracker 5-5-24 (2).xlsx

 

[awoohaw]

that workbook links to a lot of other workbooks.
Can you do this:
Please send a screen shot of the drop down rule:
select one of the drop down cells, then go to the data tab and click on Data Validation.
then screen shot that.
(Or type exactly what is the formula for the list).

But another way to fix that would be to extend the length of the list to make it longer than the source list (if you have 8000 rows, maybe you should change it 25000).
(There are probably more efficient ways to do that, but with all the disparate workbooks i think it would be confusing).

 

[Cyko]

i thought i had already sent a screen shot of that above? ( i do not have data all the way to row 1577 ( data stops on row 949). and still it only shows up to row 610 on drop down menu)i appreciate you trying to help me on this. and apologize for my limited knowledge.