• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    [VBA] Custom lookup- using arrays?

    Hey! I wrote a custom lookup function to help me out. Its a little difficult to explain, so please look at the uploaded file here. https://www.dropbox.com/s/sfb7crrql21n26p/for%20upload%20to%20forum.xlsm The cells highlighted in yellow are what I am looking up. If you notice, the snapshot...
  2. C

    Formula to match Numbers in 2 different sheet colomns

    Oh, the fatal #VALUE error! :) Most a formatting issue somewhere. See if you can clean up all your values, make sure there are no extra spaces at the end and so on. Upload a sample sheet if all else fails. VLOOKUP can pull in text data, no problem. edit: after doing some reading, I...
  3. C

    Formula to match Numbers in 2 different sheet colomns

    Hi Injinia! You could use a bunch of vlookups. Your formula in B2 would look like this: '=VLOOKUP(A2, Sheet2!B:G, 2, FALSE)' And copy downwards for the entire column in B. For C2, it will read '=VLOOKUP(A2, Sheet2!B:G, 3, FALSE)' and so on. I agree this isn't the most efficient way to...
Back
Top