TALLER INFORMATICA 4
2
TALLER Nº 4 (FUNCION BUSCAR – BUSCARV – BUSCARH )
-
Upload
pakiita-serrano -
Category
Documents
-
view
9 -
download
0
Transcript of TALLER INFORMATICA 4
![Page 1: TALLER INFORMATICA 4](https://reader036.fdocuments.co/reader036/viewer/2022071901/55c11147bb61eb56188b4654/html5/thumbnails/1.jpg)
TALLER Nº 4(FUNCION BUSCAR – BUSCARV – BUSCARH )
![Page 2: TALLER INFORMATICA 4](https://reader036.fdocuments.co/reader036/viewer/2022071901/55c11147bb61eb56188b4654/html5/thumbnails/2.jpg)
DESARROLLO (FORMULAS)
•=BUSCAR(K3;F3:F7;G3:G7)
•=BUSCAR(K6;F3:F7;H3:H7)
Función Buscar
Función BuscarH
Función BuscarV
•=CONSULTAH(C19;C16:L17;2;FALSO)
•=CONSULTAV(B14;B3:C12;2;FALSO)