Home For AAT student members AQ 2016 Advanced Diploma in Accounting Spreadsheets for Accounting
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Vlookups

Claudine71Claudine71 Registered, AAT Student Posts: 8
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

Answers

  • KrissoKrisso Registered Posts: 2
    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
Sign In or Register to comment.