Ted Penner
asked on
Excel formula components
I noticed the following excel formula components numbered 1-6. What is the proper name for those components. Where do I find a complete list of them?
=VLOOKUP(E1,A:B,2,FALSE)
1. lookup_value
2. table_array
3. col_index_num
4. range_lookup
=COUNTIF(A:A,E1)
5. range A:A
6. criteria E1
=VLOOKUP(E1,A:B,2,FALSE)
1. lookup_value
2. table_array
3. col_index_num
4. range_lookup
=COUNTIF(A:A,E1)
5. range A:A
6. criteria E1
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Office support page calls them ARGUMENTS as correctly answered by @Doug
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
For example:
=VLOOKUP(105,A2:C7,2,TRUE)
=VLOOKUP("Fontana",B2:E7,2,FALSE)
Argument name Description
lookup_value (required) The value you want to look up. The value you want to look up must be
ASKER
I think "functions" is the right programming term for VLOOKUP and COUNTIF, but I am not sure about the "parameters" or "components" that are associated with each function.