Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi vlookup on 3 sheets (2000 sr 1)

    This wbook contain 4 sheets.
    I would want to make a vlookup (in VBA naturally) on the column A of the sheet POS with all 3 sheet POS1, POS2 and POS3 and return the result of the vlookup into column COPE and NOMINATVO into sheet POS.
    The index is NDG.
    ahhhhh. if the value not is founded insert into the 2 column (cope and Nominativo) of POS sheet "non trovato"....

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Multi vlookup on 3 sheets (2000 sr 1)

    Try this. (Note: it would have been a better test if some your items had actually been in one of the lists - none of them are.)

    Steve

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi vlookup on 3 sheets (2000 sr 1)

    ok! The code work perfect...
    No problem for "...none of them are" i have posted example with not value present in pos1, pos2,pos3 and pos (i am a stupid)... but the code work well, i have tested with offcial sheet.
    For Hans: I consider you the rially wizard of this forum but sdckapr is a good "little wizard", tks sdckapr.
    Sorry for my english but my idea is this.
    Sal.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi vlookup on 3 sheets (2000 sr 1)

    Steve knows a lot more about Excel than I do! But perhaps I am better at understanding your English <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Multi vlookup on 3 sheets (2000 sr 1)

    Hans,
    Thanks for the compliment, but I think you know a lot more about excel than I do (especially about interacting with other office programs) and you seem to have more VB experience than I do.

    I have a core understanding of certain things I work with, and know them pretty well. As I move from those, my knowledge drops dramatically. I think you have a much wider breadth of knowledge and experience (especially outside excel).

    And with your extra fingers and hands you can reply much faster than I can <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi vlookup on 3 sheets (2000 sr 1)

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> Good morning Hans and tks for reply...
    Sure you have many exeprience to understand my english...
    Tks, Sal.

Posting Permissions

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