![]() ![]() When supplying an invalid lookup value, as I've done, the TRUE version returns erroneous data - this is one of the reasons it's so important to work through this function carefully. Using FALSE (column D) forces Excel to search the entire lookup column, so sorting isn't necessary. When using TRUE, the default (column C), you must sort the lookup table by the lookup column. The only difference between the functions in C2:C4 and those in D2:D4 is the use of the optional match argument. The lookup value in A1 doesn't exist in the lookup column (A). It's common to mask error values, but in this case, error values are an important clue to problems. ![]() Besides being aware of the potential problems, you'll also have to decide how to handle error values. We discussed most of them in Troubleshoot VLOOKUP() formula gotchas. The rules are simple, but you should be aware of a few inherent problems. Excel's VLOOKUP() function finds items in a list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |