Hi All,
I am trying to figure out how to allow a user to select certain cells and based on the cell selection auto populate select cells in the row.
I know you can make a table and use index match to populate the cells; however, my issue is that there is an order of operations for the checks to occur before the fields can be populated.
On the attached spreadsheet, I highlighted the cells that a user will populate and the remaining cells that would be automatically filled based on a users selection.
There are a lot of scenarios to consider from the standpoint of demonstrating all permutations; however, the actual logic is quite simple.
Any help in figuring out how I can get the same auto population that I have on sample information without doing it manually would be great.
On the spreadsheet, I list the Order of Operations for the Checks (that are followed in that order)
1) Column Purchase before Final Date
2) Unique ID
3) Type of Purchase
Then, I list the Scenarios and Outcomes based on the user selection for those 3 variables:
1) Column Purchase before Final Date = Yes - Automatically populate the columns "Purchase Matches Unique ID" and "For Credit Cards Only - Purchase Validated" with n/a. Automatically populate "Purchase Approval Status" with approved.
2) Unique ID = 1 or 2 - Automatically populate "Purchase Approval Status" with approved.
3) Type of Purchase = Cash - Automatically populate "For Credit Cards Only - Purchase Validated" with n/a.
Thanks for the help,
JuliusV
I am trying to figure out how to allow a user to select certain cells and based on the cell selection auto populate select cells in the row.
I know you can make a table and use index match to populate the cells; however, my issue is that there is an order of operations for the checks to occur before the fields can be populated.
On the attached spreadsheet, I highlighted the cells that a user will populate and the remaining cells that would be automatically filled based on a users selection.
There are a lot of scenarios to consider from the standpoint of demonstrating all permutations; however, the actual logic is quite simple.
Any help in figuring out how I can get the same auto population that I have on sample information without doing it manually would be great.
On the spreadsheet, I list the Order of Operations for the Checks (that are followed in that order)
1) Column Purchase before Final Date
2) Unique ID
3) Type of Purchase
Then, I list the Scenarios and Outcomes based on the user selection for those 3 variables:
1) Column Purchase before Final Date = Yes - Automatically populate the columns "Purchase Matches Unique ID" and "For Credit Cards Only - Purchase Validated" with n/a. Automatically populate "Purchase Approval Status" with approved.
2) Unique ID = 1 or 2 - Automatically populate "Purchase Approval Status" with approved.
3) Type of Purchase = Cash - Automatically populate "For Credit Cards Only - Purchase Validated" with n/a.
Thanks for the help,
JuliusV
