+ Reply to Thread
Results 1 to 12 of 12

Excel 2007 : VLOOKUP question

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    nashville, tennessee
    MS-Off Ver
    Excel 2007
    Posts
    33

    VLOOKUP question

    I have a column of SKU's in worksheet1 and in ws2 I have 2 columns of SKU's and 1 column of the sku description. I want to have vlookup pull the description from ws2 and populate it into a blank column in worksheet1, but I need it to search both columns of SKU's.

    Is this possible?
    Last edited by budchevy; 04-20-2011 at 08:09 PM. Reason: Solved

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: VLOOKUP question

    That should be possible using IFERROR() and VLOOKUP() combinations.

    Can you upload a small sample file (with any private data removed)?

  3. #3
    Registered User
    Join Date
    04-20-2011
    Location
    nashville, tennessee
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: VLOOKUP question

    On the RC12 w/s I have the SKU and what would normally be a blank description. I import data into the datadump w/s. I need the RC12 page to search for the SKU in column A and if it can't find the SKU I need it to search column B and then return the text from column 3.


    Now there will be instances where it won't find the SKU in either column so I need to account for that also.

    thanks..
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,215

    Re: VLOOKUP question

    Does this do what you want:

    =IF(ISNA(VLOOKUP(C2,'data dump'!A:C,3,FALSE)),IF(ISNA(VLOOKUP(C2,'data dump'!B:C,2,FALSE)),"Not Found",VLOOKUP(C2,'data dump'!B:C,2,FALSE)),VLOOKUP(C2,'data dump'!A:C,3,FALSE))

    Regards
    Last edited by TMS; 04-20-2011 at 06:09 PM.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Registered User
    Join Date
    04-20-2011
    Location
    nashville, tennessee
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: VLOOKUP question

    worked... thanks for the help

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,215

    Re: VLOOKUP question

    2007 (not tested):

    =IFERROR(VLOOKUP(C2,'data dump'!A:C,3,FALSE),IFERROR(VLOOKUP(C2,'data dump'!B:C,2,FALSE),"Not Found"))

    Regards

  7. #7
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: VLOOKUP question

    I would have said

    Please Login or Register  to view this content.
    tested

  8. #8
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: VLOOKUP question

    Regardless of your choice - don't forget to mark your thread as SOLVED.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,215

    Re: VLOOKUP question

    @Cutter: nice to have choices.

    In this case, assuming the syntax is correct, I prefer my solution as it more closely links the error condition with the formula that generated it. But whatever ...

  10. #10
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: VLOOKUP question

    @TMShucks

    I only posted mine because I only saw your first suggestion. Since OP's profile and sample file format indicate IFERROR() compatibility I didn't think your suggestion was appropriate. But by the time I posted you had already provided the IFERROR() route. As for the difference between mine and yours (2nd one) - neither here nor there.

  11. #11
    Registered User
    Join Date
    04-20-2011
    Location
    nashville, tennessee
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: VLOOKUP question

    Thank you both for the information. Great resources..

  12. #12
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,215

    Re: VLOOKUP question

    @Cutter: I have to be honest, I only posted the first solution because I was working in 2003 at the time. When I checked the profile, I thought I'd better offer the 2007 equivalent ... hence, untested. Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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