lookup explanation

  1. M

    Lookup value question

    Hello, I have a formula I'm creating in Excel file #1. It takes the value in the same position in Excel file #2 and divides by a value. It then takes a value from another sheet within file #1 and computes with other values. 1. If I reference file #2 in file #1 and both files are copied and...
  2. West Man

    vlookup with multiple matches - which match is returned

    With a formula like VLOOKUP(Z2,A2:B100,2,0) where A2:A100 is sorted ascending and there are multiple matches, it appears, with very limited testing, that the match is always the first in the range. Is this always true? I would think that a binary search would be occurring which may not always...

Some videos you may like

This Week's Hot Topics