Apr 06 2021 09:03 AM
I'm looking to have a column automatically update based on a drop down selection and 4 columns of information based. I've tried different sumif/sumifs and can't seem to get it pull correctly. Essentially what I'm trying to do is I have a person name, the drop down is 4 different rate types and the columns are the 4 different rate based on those drop downs. So if for Jane Doe said Rate 1 I would want my rate column to automatically update based on the rate 1 column I have and if Jane Doe is picked rate 2 I'd want the rate to automatically update based on the rate 2 column I have.
Apr 06 2021 10:18 AM
Apr 06 2021 10:22 AM
Perhaps you may illustrate this by sample file not to build data model based on the description and applying some assumptions which could be wrong.
Apr 06 2021 10:39 AM
@Sergei Baklan I've attached a generic example. In the summary tab I would like column G to automatically update to the correct rate based on the employee name and the drop down in column F. In the look up tab i have the rates in columns G-J
Apr 06 2021 10:54 AM
SolutionThank you. Not sure on which version of Excel you are, this formula
=INDEX('Look Up'!$G$2:$J$11, MATCH($B4,'Look Up'!$B$2:$B$11,0), MATCH($F4,'Look Up'!$G$1:$J$1,0))
shall work in any case, just adjust your ranges for actual file. Please check attached.
Apr 06 2021 10:54 AM
SolutionThank you. Not sure on which version of Excel you are, this formula
=INDEX('Look Up'!$G$2:$J$11, MATCH($B4,'Look Up'!$B$2:$B$11,0), MATCH($F4,'Look Up'!$G$1:$J$1,0))
shall work in any case, just adjust your ranges for actual file. Please check attached.