Vlookups

Options
Claudine71
Claudine71 Registered Posts: 8
in Spreadsheets for Accounting
Can anyone recommend a simple way of remembering how to use vlookups, I spent almost 20mins is my avsy exam yesterday trying to do one and I got error messages Inc one about circular references. I wasn't the only one in my class who had problems in the Synoptic. Also who has the best explanation of one Osborne or Kaplan. Thanks

Comments

  • Krisso
    Krisso Registered Posts: 124 Dedicated contributor 🦉
    Options
    The easiest way I can think to explain it is as follows

    Result (Vlookup)=((A1) cell to lookup,(B1:D20) in area to look up, (3) return the column result of that area, (False))

    I would always put false so that the search looks for an exact match as putting true will make it look for a close match and will not always return the correct result

    Hope this helps

Categories

Privacy Policy