• 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.

Recent content by mrexcelrc

  1. M

    Variable declaration

    Hi Narayan, I will try this. Thank you.
  2. M

    Variable declaration

    Hello, I recorded the macro below to import file CFLASH-AFS_PHANTOMH-20111003 in Sheet 1 then go Sheet 2 and copy paste values in cell B7 and then repeat the step to import file CFLASH-AFS_PHANTOMH-20111004" and then go to Sheet 2 and copy paste values in cell B8. My problem is I have to do...
  3. M

    Use vlookup in a lookup table where there 2 identical lookup value

    Hello Hui, I discovered that if there are more than 2 identical lookup values, the formula returns a #REF! value. Any suggestion on how to fix this?
  4. M

    Use vlookup in a lookup table where there 2 identical lookup value

    Hi, I got it to work by making the formula: INDEX(d2:d7,SUMPRODUCT((ROW(A2:A7))*(A2:A7=B11)*(D2:D7<>"Fixed"))-1 where B11 = TradeID Thanks again.
  5. M

    Use vlookup in a lookup table where there 2 identical lookup value

    Hi Hui, Thanks for this suggestion. I am getting an error presumably because I need a value for cell B11. What would be the value for B11?
  6. M

    Use vlookup in a lookup table where there 2 identical lookup value

    Hello, I need help with this formula. From the lookup table below in Sheet2, cells A1:D7, if I have a formula in cell A1 of Sheet1 as: =vlookup("50016A",Sheet2!$A$1:$D$7,4,FALSE) the formula will return a value of "FIXED" because vlookup will always look at the first lookup value and ignore...
See more
Back
Top