0
What function can be used in Excel to find info in rows based on values in a table data?
Wiki User
∙ 8y ago
There are a number of functions that could be used to achieve that. They are all categorised as lookup functions. Included in them would be ones like VLOOKUP, HLOOKUP, LOOKUP, INDEX and MATCH. You could also use the Advanced Filter facility.
Wiki User
∙ 8y ago
Wiki User
∙ 7y agoYou can use the Filter to do it.
Add your answer:
Earn +20 pts
What function is used to total table values that meet a specified criteria in Excel?
The SUMIF function.
What is an Excel reference function that looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify?
hlookup
What Excel function finds the position of an item in a table?
The MATCH function can find the position of an item in a table.
Is the uplookvert function used when the table direction is vertical or up?
Excel does not have an UPLOKVERT function. You might be thinking of VLOOKUP. You use VLOOKUP when your comparison values are located in a column to the left of the data that you want to find.
What is the definition to function table?
a table used to show values of the variable expression for a given function
Can tables in Excel be used as tables in Word?
You can copy a table in Excel and paste it into Word. You will lose any formulas, but the resulting values will be retained. You can also link a Word document to a table in Excel, which will allow changes in the Excel table to be maintained in the Word document.
What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?
The MATCH function can do that.
What excel function searches for a specific value in a table and returns that value's relative position from the table not the value itself?
The MATCH function.
What advantages can you see of having a function rule instead of a table of values?
A table of values is no use if the domain is infinite.
What is the function in Excel that will count the number of numeric entries in a table?
The COUNT function will do it. You just need to specify your table range. Say your table is from B2 to E16, then the function would be: =COUNT(B2:E16)
What function searches for a specific value in a table and returns that values relative position from the table not the value itself?
The MATCH function.
What is the Definition to function?
a table used to show values of the variable expression for a given function
