Indirect look up

[mojobaabby]

i am going nuts trying to figure out why this will not work. What am I missing. any help on shaped grill section AR6-AV6 would be appreciated.
Thanks in advance

[NBVC]

What is the actual problem?

[mojobaabby]

giving nothing in the drop down for AT6 AND AU6?

[NBVC]

What is supposed to be in the dropdowns? Where exactly is the data list supposed to come from?

[mojobaabby]

data comes from shape grill sheet which are all named correctly

[NBVC]

Well your named ranges _DVNUM and _DVTYPE don't make mention of the Shape Grills sheet.

So what exactly do you want to see in each of those drop-downs?

[mojobaabby]

AT6 should be the number from the column A3 on grill page and AU6 should be the style of grill from the row starting B2 on the grill sheet

[NBVC]

We are going in circles... if you could explain the logic, it would be probably clearer.

i.e. with CT and 1 chosen in AR6 and AS6 what should be in those dropdowns (i.e. exactly what values are to be populated).

What other options can one type in AS6? I.e. can they type 2 or 3 or 4? And if so, which table do those come from?

[mojobaabby]

ok if you look at the worksheet
AR6 dropdown applies to the tables on the shape grills sheet.
AS6 is manually entered to signify the quantity of the item needed.
AT6 should be the number associated with "CT" in Column A on the shape grill sheet.
AU6 should be the type of grill B2-F2 on the shape grill page
so they need to choose the series "CT", the quantity which is irrelevant for now, the Number and the Style

[NBVC]

For AT6 try this formula in the Data Validation window, choosing List:

=OFFSET(INDIRECT(AR6),1,0,COUNT(INDEX(INDIRECT(AR6),0,1)),1)

Note: Your CT table includes the header row, while the other don't, so adjust the named range for CT table to exclude header.

Then select B2:F2 in SHAPE GRILLS page and name that range, something like SHAPES

Then in AU6 use Data Validation|List and enter =SHAPES as the formula.

[mojobaabby]

that fixed that, still getting N/A in Aa6 so that must be messed up too

[NBVC]

You didn't ask about that....

Try:

Please Login or Register  to view this content.

[mojobaabby]

Reason I keep coming back