Excel Forum



Excel Magic Trick 335: VLOOKUP & Data Validation for Recipes


See how to take recipes listed in a column, set them up in rows, then create a drop down arrow to select recipes and display ingredients and directions.

See how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).





Got a Question? Ask it Here in the Forum.