Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2005
    Location
    Florida, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Best way to use Vlookup? (2003)

    Hi all & Happy New Year!

    I have problem deciding how to use vlookup in the attached spreadsheet.

    The objective is to find how many times a number in each cell in column A appears in columns C,D,F.
    The desireable result should be displayed as in column B Total.

    Thanks for any help!
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Best way to use Vlookup? (2003)

    You don't need VLOOKUP. You can use COUNTIF.

    Try this: =COUNTIF($C$2:$E$6,A2), and copy it down the B column using autofill.
    Regards,
    Rudi

  3. #3
    Lounger
    Join Date
    Feb 2005
    Location
    Florida, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best way to use Vlookup? (2003)

    Rudi,

    You certainly started my new year with a great smile!
    It worked, and it is simple. Thanks much!

    -Tivoli0

Posting Permissions

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