+ Reply to Thread
Results 1 to 3 of 3

VLook up help

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    VLook up help

    I don't know why I'm having such issues with VLookups of late . .

    Anyway, see attached.

    In column Q of Book 1, I am trying to return the values in column H of book 2.

    I cannot change Book 2 column F of Book 2 to "text to columns" or it jacks my formulas up.

    Help?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: VLook up help

    The zipcodes in book2 are numbers formatted as text. Even though you have changes the format to general, the original content remains text until 'fixed'.

    Either concatenate a nullstring into your formula,

    =VLOOKUP(F2&"",'book2 .xlsx'!Table_CJI5_5[[#All],[Zipcode]:[Note]],3,0)

    Or use text to columns to 'fix' the numbers.

    Select the whole of column F, then go to the Data tab, select Text to columns, then click finish, now your formulas should work.

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: VLook up help

    =vlookup(text(F2,"@"),'C:\Users\******\Documents\*****.xlsx]CJI5'!$F,$H,3,)
    Last edited by tim201110; 07-03-2016 at 12:44 PM.

+ 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. VLOOK-UP Help
    By dsheets05 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 06:24 AM
  2. [SOLVED] Vlook up
    By mahershams in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-28-2013, 05:13 AM
  3. Vlook up help
    By mel2131 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2012, 01:45 PM
  4. Vlook up help, i think
    By scotte57 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-25-2012, 07:49 PM
  5. vlook up
    By syed abbas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2007, 06:10 AM
  6. Vlook Up Help
    By nander in forum Excel General
    Replies: 1
    Last Post: 10-19-2006, 04:56 AM
  7. [SOLVED] Vlook
    By bimseun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2006, 06:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1