+ Reply to Thread
Results 1 to 5 of 5

VLOOKUP to match values to name

  1. 06-30-2015, 02:16 PM #1
    xps15z
    xps15z is offline
    Registered User
    Join Date
    06-30-2015
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    3

    VLOOKUP to match values to name

    I am getting values returned as "0" or "FALSE" when trying to organize my Excel sheet.

    I have column A (SKU), Column B (price) and Column E (organized SKU). I want to have the prices to also show on Column E since that is the organized column. That way I can delete Column A.

    The last thing I tried which by eyes no longer even looks correct is "=VLOOKUP(E2,B2,F2+A2,FALSE)"

    What would be the correct formula to complete this simple task? It's been over a year since I've touch vlookup and I have obviously lost my touch!
    Reply With QuoteRegister To Reply
  2. 06-30-2015, 02:20 PM #2
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: VLOOKUP to match values to name

    Does this help?
    Please Login or Register  to view this content.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
    Reply With QuoteRegister To Reply
  3. 06-30-2015, 02:22 PM #3
    xps15z
    xps15z is offline
    Registered User
    Join Date
    06-30-2015
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    3

    Re: VLOOKUP to match values to name

    I have it now. Should be =VLOOKUP(E4,A:B,2,FALSE) . I'm rusty sorry
    Reply With QuoteRegister To Reply
  4. 06-30-2015, 02:23 PM #4
    xps15z
    xps15z is offline
    Registered User
    Join Date
    06-30-2015
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    3

    Re: VLOOKUP to match values to name

    nigel, yes your correct. Ha I did it before you submitted. But yes you match with mines.
    Reply With QuoteRegister To Reply
  5. 06-30-2015, 02:24 PM #5
    bhenlee
    bhenlee is offline
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: VLOOKUP to match values to name

    hi xps15z

    try using:

    =VLOOKUP(E2,A:B,2,0)

    copy down in column F.

    Let me know if it works.
    If I've helped U pls click on d *Add Reputation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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/index/match to return all values that match
    By Asil01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-09-2014, 12:49 PM
  2. Using VLOOKUP or INDEX/MATCH to pull values from a table that match any one of a list
    By rjaswift in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  3. VLOOKUP/INDEX/MATCH to return all values that match
    By lijia00 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 11:56 AM
  4. [SOLVED] VLOOKUP match on first x values or ignore last x values - partial match
    By bobtu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2014, 10:00 PM
  5. VLOOKUP match on first x values or ignore last x values - partial match
    By bobtu in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2014, 01:30 PM

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