Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2001
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    conditional vlookup? (97 SR2 (h))

    Greetings Loungers!

    Ok, so I have 2 spreadsheets.

    Let's say they look like these.

    see first sheet

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: conditional vlookup? (97 SR2 (h))

    shouldn't it be a ",FALSE" type of VLOOKUP?

  3. #3
    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: conditional vlookup? (97 SR2 (h))

    Yes. You are correct. I was only thinking about the columns and NOT exact matching. I changed it in my original note

    Steve

  4. #4
    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: conditional vlookup? (97 SR2 (h))

    <P ID="edit" class=small>(Edited by sdckapr on 12-Aug-03 14:48. Changed to fix TRUE to FALSE to find Exact match)</P>IN your first sheet make a column (eg insert new C between B & C, col D NOW has animals) COMBINES first and last names (=b1&A1) and copy it down. Then use
    =VLOOKUP(b1&A1,'other sheet'!$C$1:$C$3,2,FALSE)

    FYI, "Adams" is misspelled. The characters are from the ADDAMS Family (2 Ds)!

    Steve

Posting Permissions

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