Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Vlookup loop needed. (https://www.askmehelpdesk.com/showthread.php?t=416712)

  • Nov 17, 2009, 02:52 AM
    rsdjimbie
    1 Attachment(s)
    Vlookup loop needed.
    Hi,
    Please refer to attachment.

    For sheets "Prod A to Prod D".

    Select sheet "Prod B" row marked in yellow;

    If col."L" = "Emb" then col. "Q" = value.
    Value is the loop I'm after;
    Value in "Q"= Vlookup value in col."A" on sheet "Emb" col. "A", and if col. "F" - "G"=0 on sheets "Emb" then Value col. "Q" on sheets "Prod B" should change to yes. :(
  • Nov 17, 2009, 10:50 AM
    JBeaucaire

    The formula for Q11:

    =IF(L11<>"Emb", "", IF(INDEX(Emb!F:F, MATCH(A11, Emb!A:A, 0)) - INDEX(Emb!G:G, MATCH(A11, Emb!A:A, 0))=0, "Yes", "No"))

    • All times are GMT -7. The time now is 12:54 AM.