Results 1 to 9 of 9

VLOOKUP to Match Partial Strings

Threaded View

  1. 07-21-2019, 02:42 AM #1
    Captain89
    Captain89 is offline
    Registered User
    Join Date
    07-21-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    7

    Lightbulb VLOOKUP to Match Partial Strings

    Hi guys, need some help below.

    I have a sheet A data of 4 digits (3numbers 1 alphabet). And another sheet B data of 8 Digits.
    My lookup value is Sheet A and Table_array is Sheet B (meaning Sheet A 4 digits numbers are the last 4 digits in Sheet B and i need to lookup to see if they belong to sheet B.)
    So example sheet A is 321H, sheet B has 7654321H. So if i input a formula, result should turn out "321H". If not, it should be "#N/A"

    Anyone wise ppl can advise me the formula to do so?
    Attached Files Attached Files
    Last edited by Captain89; 07-21-2019 at 03:50 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup Error - unable to get the vlookup property of the worksheetfunction class
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2019, 02:59 PM
  2. [SOLVED] Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP
    By robertguy in forum Excel General
    Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  3. Find max value in range then vlookup text in correspond col header & vlookup to table
    By jcskwells in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  4. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  5. how to bring all vlookup returns even with duplicate vlookup search keys
    By NYC4LIFE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2013, 04:53 PM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. Howto: Vlookup looping (for each...next?). Advise needed about Vlookup loop technique
    By Wino in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 07:53 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1