Results 1 to 10 of 10

Finding Values in one random list, highlighting, and labeling based on a known list

Threaded View

  1. #8
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,100

    Re: Finding Values in one random list, highlighting, and labeling based on a known list

    vlookup with a false will only return exact values same as index/match with 0 option

    is the phone number in sheet calls at all

    I have added in cell G a number and H
    =INDEX('Phone book'!$A$2:$A$10, MATCH(G2, 'Phone book'!$B$2:$B$10, 0))
    a lookup using index match

    see attached
    Attached Files Attached Files

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