{"id":1566,"date":"2016-04-28T12:18:52","date_gmt":"2016-04-28T20:18:52","guid":{"rendered":"http:\/\/www.auval.com.mx\/notas\/?p=1566"},"modified":"2016-04-28T12:18:52","modified_gmt":"2016-04-28T20:18:52","slug":"formula-matricial-para-regresar-varios-valores","status":"publish","type":"post","link":"https:\/\/auval.com.mx\/blog\/2016\/04\/28\/formula-matricial-para-regresar-varios-valores\/","title":{"rendered":"F\u00f3rmula matricial para regresar varios valores"},"content":{"rendered":"<p>Aqu\u00ed les dejo un video de c\u00f3mo hacer una f\u00f3rmula matricial para encontrar varios valores. Es algo as\u00ed como un VLOOKUP\/BUSCARV m\u00faltiple.<\/p>\n<p>Las funciones que uso se llaman as\u00ed en espa\u00f1ol:<\/p>\n<p>IF = SI<\/p>\n<p>SMALL = K.ESIMO.MENOR (ya s\u00e9, yo le hubiera puesto \u00abCHICO\u00bb o algo as\u00ed)<\/p>\n<p>ROW = FILA<\/p>\n<p>INDEX = INDICE<\/p>\n<p>IFERROR = SI.ERROR (o SIERROR si tiene Excel 2010 sin service pack)<\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00f3mo hacer una f\u00f3rmula matricial para buscar varios valores (con Excel en ingl\u00e9s)\" width=\"605\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/pTXRm6NHSNA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aqu\u00ed les dejo un video de c\u00f3mo hacer una f\u00f3rmula matricial para encontrar varios valores. Es algo as\u00ed como un VLOOKUP\/BUSCARV m\u00faltiple. Las funciones que uso se llaman as\u00ed en espa\u00f1ol: IF = SI SMALL = K.ESIMO.MENOR (ya s\u00e9, yo &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/auval.com.mx\/blog\/2016\/04\/28\/formula-matricial-para-regresar-varios-valores\/\"> <span class=\"screen-reader-text\">F\u00f3rmula matricial para regresar varios valores<\/span> Leer m\u00e1s \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1566","post","type-post","status-publish","format-standard","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/comments?post=1566"}],"version-history":[{"count":0,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1566\/revisions"}],"wp:attachment":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/media?parent=1566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/categories?post=1566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/tags?post=1566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}