Auto Populate a Cell

[Ken]

I have an excel spreadsheet with three columns, Insurance, Provider
Credintials and Modifier. What I'd like to do is for someone to enter the
insurer name, then the provider credentials, once this is entered, I would
like the modifier cell to populate a specific modifier based on a combination
of the two previous fields.

Example. Insurer Provider Credintials Excel Auto Populate Value

XYZ Insurance XYZ credentials Fields brings in
value XX (from table)

(I'm between a beginner and intermediate user of excel, so please explain in
detail). Thanks very much for any assistance.

 

[Jacob Skaria]

Hi Ken

Forgot to mention that; the earlier formula which I posted will work only if
the modifier column contains a numeric value..The formula actually returns
the sum of col C based on the 2 criterias specified...So inorder to work your
data in colc should be numeric values and there should not be any duplicate
records...for the same matching criterias....

Here is the deal. If the 3rd column is a text field/or numeric with
duplciate records you will need to use an array formula

=INDEX($C$2:$C$10,MATCH(1,($A$2:$A$10=criteria1)*
($B$2:$B$10=criteria2),0))

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"


If this post helps click Yes

 

[Jacob Skaria]

Ryan, Im sorry; the OP is not looking for a horizontal and vertical matching
record from a table. Even if that is the case you still can pull that using
=VLOOKUP(value,arrray,MATCH(),0) without using multiple MATCH() functions
and INDEX().