+ Reply to Thread
Results 1 to 2 of 2

Vlookup with different lookup value

  1. #1
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Vlookup with different lookup value

    Dear Friends,
    I tried used vlookup formula but with different lookup value, is not work.
    please help to advise with formula needed.
    attached file for sample.

    Thank you in advance for your help

    Regards,
    Wie
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Vlookup with different lookup value

    Try:
    =VLOOKUP("*"&A3,Data!$A$2:$B$5,2,0)

    with * mean "whatever before value of cell A3"
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Match and Vlookup to find the lookup range for a Vlookup
    By locopete999 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2017, 09:09 AM
  2. [SOLVED] VLOOKUP, gives #N/A error (if Range lookup=0) or wrong data (if Range lookup=empty)
    By Ebalinska in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-14-2016, 05:55 AM
  3. [SOLVED] VLOOKUP, 2 lookup values; then sum the lookup returned
    By pricepeeler in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-17-2014, 03:17 PM
  4. How to use vlookup if value of lookup cell is same in lookup range
    By anujteetwal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2014, 05:15 AM
  5. Excel 2007 : Lookup, Vlookup, or IF
    By Rick K in forum Excel General
    Replies: 4
    Last Post: 06-14-2011, 12:35 PM
  6. Excel 2007 : Lookup/Vlookup using two Lookup values
    By Rick K in forum Excel General
    Replies: 4
    Last Post: 09-16-2010, 02:16 PM
  7. [SOLVED] Lookup without VLOOKUP?
    By J in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 11-17-2005, 03:00 AM

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