Vlookups

Claudine71

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

Krisso

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