Matching value to column and row dependency list.. Please help

[sarah112]

Hi All,

I've been struggling with dependencies, so I have two sheets.. the first sheet contains a simple table:

Employee Username Status Status Note
Alex
Josh
Sarah
David

This is the second table:

Employee Username Active Password Change Days Since Change
Alex al2 Y Y 20
Alex alex Y Y 11
Alex aa2 N N 0
Josh josh2 Y Y 10
Sarah ssarah N N 0
Sarah sarah Y Y 1
David David Y Y 4

The problem is in the first table as I don't know how to populate the "Status Note" column which depends on these two columns
The column Username which is a dependent list from table 2 that contains the username associated with each employee selection
The column Status which is a dropdown list that contains (Active, Password Change, and Days Since Change)

For example if the following is selected for user Alex: al2 and Active how can I make Excel display Y in the status note column
Employee Employee Username Status Status Note
Alex al2 Active Y
Josh
Sarah
David


Any help is greatly appreciated ! Thank you in advance

[Jul Stev]

Hi Sarah112,

Assuming that the username is unique and cant be duplicated, you can just use vlookup to search for the status, or there is something i miss?

See attached file and tell me if there is something wrong.

Book1.xlsx

[sarah112]

Hi Jul Stev,

Thanks for your reply. This function would work if I was only trying to base the result on the username column.. but I want to find the result based on the choices made in two columns B & C drop down lists (Username and Status).. I've attached my file.. For example when I select al2 in column B and Days Since Change in column C I would get 20.. I wasn't able to make this happen and get the result I want in column D

Workbook1.xlsx

[Jul Stev]

Hi Sarah112.

Sorry for the late reply, didn't notice it..

Please see the attach file, hope this help..

Workbook1update.xlsx