Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Vlookup Across Multiple Columns

  1. #1
    Guest

    Default

    I need to compare several columns in two separate worksheets. I can do that by making long records of each row (A1&B1&C1, etc.) then doing a vlookup on the long records to find the exact matches, but that seems ackward.

    Is there a form of vlookuop that will allow comparing across several columns? (8 columns in my application)

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I have a Custom function written here that will do this. Just ad an If statement to include only the sheets you want.



  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the instant response Dave, but I don't see your code. Do I need some special setting in my Internet Explorer?

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oops sorry, my fault I forgot the link )


    http://www.ozgrid.com/VBA/VlookupAllSheets.htm

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a small programme..

    compare range..

    you can download it from my excel site..

    http://www.pexcel.com/download.htm


    i think this small utility can be useful to you.
    ni****h desai

    [ This Message was edited by: nisht on 2002-03-09 21:11 ]

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
  •