Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Stupid Question of the day. (re: VLOOKUP)

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    London, Ontario, Canada
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Hi, sorry this is probably a lame question.

    Is there any way to get VLookup (or any other function/formula) to give me all the info in a row instead of just what matches?

    I have VLOOKUP working just fine, I want to display multiple cells however.

    Thanks,


  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    SuperSean,

    What kind of info?

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    London, Ontario, Canada
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Heya,

    I have food suppliers costs, product names id # ect in a big big list, needed to pull info from the big list and stick it on a smaller list for other people to see.
    I eventually figured it out, though there may have been a quicker way, I did a vlookup for each catagory based on the criteria of the original search.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey Sean,

    I'm pretty sure you'll need a vlookup per column of data you're pulling in. You may be able to moph a single copy-able formula by automating the column reference in the vlookup.

    For example instead of:

    =Vlookup(A2,Sheet2!A2:E200,2,false) --where you'd just change the ,2, to ,3, in the next column over)

    try:

    =Vlookup(A2,Sheet2!A2:E200,Column(Sheet2!A2)+1,false)

    The advantage would be that you can copy this Vlookup and pull the correct data.

    Tweak where necessary
    Adam

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    London, Ontario, Canada
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Adam!

    You were correct, this is what I did:

    =VLOOKUP(Sheet3!$A10,Sheet1!$A$2:$E$3104,1,FALSE)

    I then just draged it down to the other cells I needed to , copied it across ect...


    Thanks for your help.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •