IT Log

Record various IT issues and difficulties.

Tag: Lookup Table Structure


  • Why do the numbers pulled down using the VLOOKUP function appear equal

    When using the VLOOKUP function in Excel, if the numbers pulled down appear equal, it may be due to several reasons: Data Consistency: The values being looked up might be consistent across rows, causing the same result to display each time. Absolute References: If the formula uses absolute references (e.g., $A$1), Excel will reference the…