Skip to content
Engineers Tools
Primary Navigation Menu
Menu
  • Home
  • Software
    • Chemical Engineering
    • Electrical Engineering
      • Transformers
    • Mathematics and Calculations
    • Mechanical Engineering
    • Modelling and Design
    • Productivity
  • Books
    • Electrical Engineering
  • Articles
    • Software Recipes
  • Shop
  • Contact Us

Data Table

Excel Lookups in any Direction

2016-01-16
In Software Recipes
Tagged Data Table, excel, HLookup, Search, VLookup

Short Description Perform searches in Excel rows or columns and extract data in any direction from the found reference. The final form of this recipe is: Searching a column and returning a value in another column =INDEX(<Column to extract value from>,MATCH(<Value of criteria used for looking>,<Column to be searched for value>,0)) Searching a row and returning a value in another row =INDEX(<Row to extract value from>,1,MATCH(<Value of criteria used for looking>,<Row to be searched for value>,0)) Ingredients Microsoft Excel The Need In many scenarios, data held in the form of a table needs to be searched for a certain criteria and when the criteria is met some pieceRead More →

Search

Catalogue

  • Chemical Engineering
    • Avogadro
    • MolView
  • Electrical Engineering
    • Harmonics Visualiser
    • Power Quality Teaching Tool
    • Symmetrical Components
    • Transformers
      • RALE – Transformer Design Software
      • xDGA
  • Mathematics and Calculations
    • SageMath
    • SMath Studio
  • Mechanical Engineering
    • OpendTect
  • Modelling and Design
    • Agros2D
    • FreeCAD
    • SketchUp
    • Tinkercad
    • Z88Aurora
  • Productivity
    • 1Password
    • WinWriter

Topics

analysis algorithms Application Settings artificialintelligence CAD Calculations Chemical Computer Aided Design Data Table dga excel formulas dissolved gas analysis document automation document generation Drawing duval pentagons duval triangles Education Electrical Engineering excel excel add-ins excel automation FEA FEM Finite Element Analysis Finite Element Modelling HLookup how to iec 60599 ieee c57.104 machinelearning Mathematics Modelling Molecules Office Physics power transformers power transformers oil analysis Ribbon rodgers rations Search UI vba VLookup word work instructions xDGA

About Us

  • Our Story
  • Privacy Policy

Copyright © 2021 Engineers Tools