Results 1 to 5 of 5

Thread: Vlookup within a Vlookup or something else?

  1. #1

    Vlookup within a Vlookup or something else?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all, I need to look up a value based on two search criteria:

    1) the month and year must match but not the exact date

    2) The reference number must match (The range being searched has other text too so search will based on 'contains text' sort of thing)

    I can't quite figure out what formula I use and how do I implement it..any help would be much appreciated.

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,250
    Articles
    0
    Hi

    attaching a sample sheet might help

  3. #3
    Thanks but cannot see any attachment ?

    Quote Originally Posted by Pecoflyer View Post
    Hi

    attaching a sample sheet might help

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,250
    Articles
    0
    Edit your post click " Go advanced" and click on the paperclip icon, then follow the instructions to upload. ( uploading a sheet instead of an image makes things easier for everybody )
    Last edited by Pecoflyer; 2011-12-31 at 03:03 PM.

  5. #5
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    335
    Articles
    0
    Or in a new post click reply>Go advanced and you'll see the attachment tools there as Pecoflyer explained.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

Posting Permissions

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