How do I create a formula that will find a specific value in a large table of data? - large tables
I have a large table in an Excel file with names in the header of the first column in the front row.
I want a formula in another worksheet where I can create a name and a Head and the formula is a reference to the table and returns the correct data.
Wednesday, January 13, 2010
Large Tables How Do I Create A Formula That Will Find A Specific Value In A Large Table Of Data?
2 comments:
Use the search function.
SEARCH (lookup_value, lookup_vector, resu ...
Lookup_value research value for research in the first vector. Search criterion can be a number, text, logical value, a name or reference that refers to a value.
Lookup_Vector an area that contains only one row or column. The values in lookup_vector can be text, numbers or logical values.
Important: The values in lookup_vector must be in ascending order: ...,- 2, -1, 0, 1, 2, be made ..., AZ, false, true, otherwise REFERENCE may not the correct value. The text in uppercase and lowercase letters are equivalent.
Result vector is an area that contains only one row or column. Have the same size as lookup_vector.
Help this helps
Use the search function.
SEARCH (lookup_value, lookup_vector, resu ...
Lookup_value research value for research in the first vector. Search criterion can be a number, text, logical value, a name or reference that refers to a value.
Lookup_Vector an area that contains only one row or column. The values in lookup_vector can be text, numbers or logical values.
Important: The values in lookup_vector must be in ascending order: ...,- 2, -1, 0, 1, 2, be made ..., AZ, false, true, otherwise REFERENCE may not the correct value. The text in uppercase and lowercase letters are equivalent.
Result vector is an area that contains only one row or column. Have the same size as lookup_vector.
Help this helps
Post a Comment