+ Reply to Thread
Results 1 to 3 of 3

Match Columns/ Return Value of Next Column

  1. #1
    Forum Contributor
    Join Date
    05-01-2018
    Location
    Maine
    MS-Off Ver
    2010
    Posts
    114

    Match Columns/ Return Value of Next Column

    Hello,

    I have used Vlookup formulas before but I seem to be stumped with one I am currently working on. Im not even sure if Vlookup is the correct type for what I am needing. I would greatly appreciate any assistance.

    I have item numbers in column B that will stretch down to about 15000 rows, both letters and numbers.
    I will have data in Column L and use a =RIGHT equation to get the item number from column L and populate that in Column M.

    All that to say that if a match is found in column M and B then I need it to return the C & D columns of the match. I keep getting an N/A error rather I try to use Vlookup or some type of MATCH formula. I think it may be because the formula =RIGHT isnt formatting correctly... but im not sure. I attached an example workbook to this post.

    Thank you in advance for any assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Match Columns/ Return Value of Next Column

    In M4

    =TRIM(RIGHT(L4,LEN(L4)-FIND(": ",L4))) to remove extraneous blanks

    in N4

    =IFERROR(VLOOKUP(M4,$B$4:$C$15000,2,FALSE),"")

    in O4

    =IFERROR(VLOOKUP(M4,$B$4:$D$15000,3,FALSE),"")

    Look at VLOOKUP function to understand how it works

  3. #3
    Forum Contributor
    Join Date
    05-01-2018
    Location
    Maine
    MS-Off Ver
    2010
    Posts
    114

    Re: Match Columns/ Return Value of Next Column

    Thank you for the information. I tried to keep it simple in that Example workbook but I think I have another formula that have the spaces you mentioned below and its causing issues. Can you tell me how to get rid of blanks in this:
    Please Login or Register  to view this content.
    [/CODE]

+ 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. Match Three Columns to Return a Value in another Column
    By MotorcycleGuy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2017, 07:50 PM
  2. [SOLVED] Need to match two columns and return a third column value from a table
    By HRGIRL16 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2017, 02:18 AM
  3. Replies: 9
    Last Post: 12-16-2013, 04:02 AM
  4. Replies: 20
    Last Post: 04-15-2013, 01:06 PM
  5. Replies: 3
    Last Post: 05-24-2012, 10:10 AM
  6. Match 2 columns in 2 sheets and return the 3rd column
    By swadson in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-16-2011, 04:36 PM
  7. Replies: 6
    Last Post: 03-01-2011, 06:23 PM

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