using an IF with VLOOKUP to spawn a pop up menu from another sheet

HI r'

"SO, my next question is, can i use an IF statement with a VLOOPUP to pull in the pop up menu from another sheet???

LIKE THIS..... IF(E2="GILDAN 2000",VLOOKUP(SHIRT COLORS::A,1,""))"

No.

VLOOKUP will return the value in the cell it finds. Pop-up menu is a "Data Format", not a value. If pointed to a Pop-up menu cell, VLOOKUP will return the value currently displayed in that cell.

The error message you mention is due to the way you have constructed VLOOKUP.

VLOOKUP's first argument is search-for, which you've put into the IF statement.

VLOOKUP's second argument is columns-range, which you've placed as the first argument in VLOOKUP.

VLOOKUP's third argument is the number (1) of the column from which the located value is to be returned. You've placed 1 as the second argument for lookup.

"" is what you want IF to return if its expression is FALSE. ,"" should be after the first closing parenthesis and before the second.

IF isn't necessary here.

More to come later.

Regards,

Barry

Hi r'

"the nested pops up will not work because i have a merged cells in the table and it will not let me use the ADD A FILTER the show/hide the popup menus."

It appears you have two choices:

1. Get rid of the merged cells to permit use of cascading pop-ups OR
2. Keep the merged cells and forget the cascading pop-ups.

You might consider using a Slider or a Stepper cell for your colour choices.

Here's an example using pop-ups in column A and Steppers in column B of the Main table.

All cells in column A (except A1) contain a pop-up menu with three items (the three shown in column A), set to Start with blank.

All cells in column B (except B1) are formatted as Steppers with the value range 1-9,

Cells in column C contain the formula shown below the table, entered in C2, and filled down to the end of the table.

C2: INDEX(Data::A:C,B2+1,MATCH(A2,Data::$1:$1,0))

Formulas work from inside out, and from left to right on the same level.

MATCH searches-for the value in A2 of 'this table' in row 1 of Data, and returns a number indicating the column in which that text is found.

INDEX looks in columns A to C of Data for the cell that is at the intersection of the row indicated by the number chosen in B2, + 1 to adjust for the header row, and the column indicated by the number returned by MATCH, and returns the data in the cell at that location.

Note the results in Main::C9, where the result cell is empty, and in C10, where Match has no value to look for.

Regards,

Barry