Google Sheets - Simple VLOOKUP with Double Drop Down Data Validation-CodePudding

Home > Software engineering > Google Sheets - Simple VLOOKUP with Double Drop Down Data Validation

Google Sheets - Simple VLOOKUP with Double Drop Down Data Validation

Time：01-18

I have a simple request that combines Data Validation with VLOOKUP.

On my Pending worksheet, when you select a Website - it should create a dropdown in the next column showing only the email addresses assigned to that website within the Profiles worksheet. Lastly, when you select an Email in the newly created dropdown - the next column should show the correct Name that's assigned to that Email-Website combination.

Here's my Google Sheet:

Modifying Data:

Page link：https//www.codepudding.com/Softwareengineering/266769.html

Prev:Filter by two conditions Array Formula alternative in google sheets

Next:Google Sheets - Conditional Formatting Color Scale for Text, Not the Background

Tags：

Links：
CodePudding