Results 1 to 6 of 6

Vlookup and concatenate

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    Vlookup and concatenate

    Hello All,
    I hope this message finds you all well.
    I must admit I'm in a little over my head here. What I trying to accomplish is to combine a Vlookup and concatenate function. On sheet 1 I have two inputs - company code and credit account. These two values need to be used as my lookup_value in my Vlookup function. On sheet 2, I need to find the rating (column "I").
    Could someone help me here?

    I know I could add a column to Sheet 2 and concatenate the credit account and company code and then use Vlookup. However, I would like to not have to do that. All help and suggestions are welcomed!

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup and Concatenate
    By Tim204030 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2015, 04:36 PM
  2. [SOLVED] Concatenate/VLOOKUP
    By Jerche12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-30-2014, 02:08 AM
  3. [SOLVED] Please Help vlookup a CONCATENATE
    By jamesnos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2014, 02:11 AM
  4. [SOLVED] Vlookup using Concatenate
    By dash11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2012, 07:54 PM
  5. Excel 2007 : vlookup and CONCATENATE
    By Jerseynjphillypa in forum Excel General
    Replies: 4
    Last Post: 11-04-2011, 09:38 AM
  6. Vlookup with concatenate?
    By Lolprotiens in forum Excel General
    Replies: 5
    Last Post: 05-01-2011, 09:29 PM
  7. Vlookup & Concatenate
    By AK262007 in forum Excel General
    Replies: 2
    Last Post: 03-20-2009, 11:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1