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

  1. W

    Find function combined with "if not found then do this. .

    That absolutely worked. . .Thank you so very much!!
  2. W

    Find function combined with "if not found then do this. .

    My find function is =MID(G5,FIND("LI",G5),7), but what can be done if "LI" is not found and I want to return a value of =right(G5,7)?
  3. W

    Two cells in different workbooks have the exact number, why does the VLOOKUP not find in an array?

    Thank everyone for your great help. Oddly, the problem was resolved copying one of the cells and using "special paste" values and number formats
  4. W

    Two cells in different workbooks have the exact number, why does the VLOOKUP not find in an array?

    It is important to note: that one of the cells contents was generated by a formula, and in the other workbook the exact same number exists not generated by a formula. When I key-in the number in the workbook with the cell derived by a formula the VLOOKUP array does find the cell and produces...
  5. W

    Two cells in different workbooks have the exact number, why does the VLOOKUP not find in an array?

    11/5/2015 DNS JEH 8:00 8:30 1 BAL GRANDE-MERCADO, GLENDA XIOMARA @ 205-475-594 ARMV 25 Released ES TABE, KEVIN M., ESQ. SP I P 205475594
  6. W

    Move the contents of a cell X rows/columns

    I just managed to make your suggestion work. I have a number of cells that I have to cut the contents and move down 7 and right 7
  7. W

    Move the contents of a cell X rows/columns

    Where I am deeply grateful, this is above my head. I do not know how to use VBA. I have tried in the past. Again,
  8. W

    Move the contents of a cell X rows/columns

    How do I copy the contents of a cell and move that value down 7 rows and left/right 7 columns?
  9. W

    IF statements with multiple variables

    You are the best! I am grateful, thank you!!
  10. W

    IF statements with multiple variables

    How do I construct an IF statement with multiple variables: =IF(C2=D2,"",IF(C2="FB", Move, "Request")) This statement says if C2 = "FB" then "Move" otherwise "Request. And works for only the value "FB" but I need the statement to evaluate IF(C2="FB, MCL, AVB, WSR, and so on. . .in other words...
  11. W

    IF statement with multiple conditions

    =IF(C2=D2,"",IF(C2="FB","Move","Request"))
See more
Back
Top