+ Reply to Thread
Results 1 to 2 of 2

ISNA vlookup return matched result

  1. #1
    Registered User
    Join Date
    02-09-2005
    Posts
    2

    Question ISNA vlookup return matched result

    I have created the following function to cross reference a cell holing a number with a range of cells holding numbers on another sheet, using false for identical match. My problem is that I need to return the value of an adjacent cell to that of the true matched result.

    =IF(ISNA(VLOOKUP(A13,'FAX CONTROL INFO'!$L$2:$L$1061,1,FALSE)),"'FAX CONTROL INFO'!N13","Yes")

    For example:

    sheet1
    A
    ==|===|
    1 | 10
    2 | 11
    3 | 12

    sheet2
    A B
    ==|===|====|
    1 | 10 john
    2 | 11 fred
    3 | 12 bill

    My look up would check to see if sheet1, A1 exists within range sheet2, A1:A3 and return B1 as it is a true match with sheet2, A1 - hope this makes sense. As a note, I will have multiple matches but only need to return one result as all matches would be the same.

    If anyone has done this sort of thing before and can help me out or point me to another resources it would be much appreciated – thanks for your time.

  2. #2
    Registered User
    Join Date
    02-09-2005
    Posts
    2

    Talking All Fixed

    =vlookup(a10,'fax Control Info'!l$2:n$1061,3,false)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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