few weeks ago I received a query about how to work with a crosstab. Suppose the following case a variable depends on two parameters. The following chart shows a crosstab where depending on the temperature and deformation of a metal results in a factor.
Suppose then that we need to find the factor for a temperature of 27 º and 2.75 strain. First, consider using or VLOOKUP VLOOKUP in Excel 2007. Remember how these features work:
VLOOKUP (lookup_value, rango_busqueda; columna_para_devolver_valor; [true or false])
HLOOKUP (lookup_value, rango_busqueda; fila_para_devolver_valor; [true or false])
see that if we use any of the two functions need to know the number of row or column from which we extract the value you want, then either we use VLOOKUP or HLOOKUP , we must give to deformation or temperature numbers 1,2,3,4, etc as a column or row. To do this we use the MATCH function that returns the location of an element within an array, this function has the following syntax :
MATCH (lookup_value, rango_búsqueda)
Combining VLOOKUP or HLOOKUP with MATCH can extract elements of a crosstab. You can download this file to see the application. Good luck.
0 comments:
Post a Comment