Results 1 to 9 of 9

Vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Sweden
    Posts
    5

    Question Vlookup

    How do you solve the following;

    If the range_lookup argument is FALSE, VLOOKUP will find only an exact match. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.

    For example if I would like the function to read from something called TX1, TX2, TX3 and TX4, and then I add TX up to TX14, then the function will read 14 as 1 (the first digit in the number).
    Last edited by Bellen; 06-15-2010 at 10:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1