+ Reply to Thread
Results 1 to 7 of 7

Need some help with lookup - I need to refer to a table and insert relevant info.

  1. 08-26-2009, 10:14 AM #1
    Claire_Louise
    Claire_Louise is offline
    Registered User
    Join Date
    08-26-2009
    Location
    Midlands
    MS-Off Ver
    Excel 2003
    Posts
    6

    Need some help with lookup - I need to refer to a table and insert relevant info.

    I have a work sheet containing various information including Store, Product Number, Quantity. I then have a separate sheet containing Product Number and Product Description. I would like to add the Product Description next to the Product Number in the first sheet.

    The Product Number may appear several times and in a random order so I need to do some sort of lookup to say if Product Number = x then look up x on the second sheet and take the Description from the next column.

    I hope this makes sense? Can anyone help?

    Claire
    Last edited by Claire_Louise; 08-26-2009 at 10:19 AM.
    Reply With QuoteRegister To Reply
  2. 08-26-2009, 10:25 AM #2
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Need some help with lookup - I need to refer to a table and insert relevant info.

    Hi and welcome to the board

    Would the VLOOKUP function help?
    Reply With QuoteRegister To Reply
  3. 08-26-2009, 10:31 AM #3
    Claire_Louise
    Claire_Louise is offline
    Registered User
    Join Date
    08-26-2009
    Location
    Midlands
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need some help with lookup - I need to refer to a table and insert relevant info.

    I'm sure... I don't know where to start.
    Reply With QuoteRegister To Reply
  4. 08-26-2009, 10:38 AM #4
    Claire_Louise
    Claire_Louise is offline
    Registered User
    Join Date
    08-26-2009
    Location
    Midlands
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need some help with lookup - I need to refer to a table and insert relevant info.

    I mean I'm not sure. I think that is the sort of thing but I'm not very knowledgeable about this.
    Reply With QuoteRegister To Reply
  5. 08-26-2009, 10:44 AM #5
    Chemistification
    Chemistification is offline
    Forum Contributor
    Join Date
    08-19-2009
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: Need some help with lookup - I need to refer to a table and insert relevant info.

    Fora a quick look please see the attached file. I would look into how to use v lookups properly tho as a lot can go wrong if you dont understand them
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 08-26-2009, 11:00 AM #6
    Claire_Louise
    Claire_Louise is offline
    Registered User
    Join Date
    08-26-2009
    Location
    Midlands
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Need some help with lookup - I need to refer to a table and insert relevant info.

    Thanks this is really helpful. I have managed to crack it but then when I have copied it to the other cells it isn't working. I will research V LOOKUP in more detail but I need to get this sheet sorted quickly and wondered if you could advise.

    Thanks Again,

    Claire
    Reply With QuoteRegister To Reply
  7. 08-26-2009, 03:17 PM #7
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Need some help with lookup - I need to refer to a table and insert relevant info.

    Your example seems ok
    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)

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