Ask Experts Questions for FREE Help !
Ask
    rsdjimbie's Avatar
    rsdjimbie Posts: 96, Reputation: 3
    Junior Member
     
    #1

    Nov 17, 2009, 02:52 AM
    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. :(
    Attached Files
  1. File Type: zip Sheets.zip (72.8 KB, 34 views)
  2. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Nov 17, 2009, 10:50 AM

    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"))

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Loop for payslips needed. [ 3 Answers ]

Please refer to attached worksheet. I need a loop that will fill cells marked in yellow on sheet "PaySlip", with data read from sheet "All Dpts" starting at R4C2 and ending when col. C is blank. There are blank rows between R4 and R1111, because these deprtments as shown in Col A, shrink and...

Vlookup what does that mean. [ 3 Answers ]

Can any one tellme.. what does vlookup formula mean in excel...

Vlookup formula [ 2 Answers ]

I am currently using MS-Excel 2003. Having a terrible time with Vlookup. The concept seems easy enough – but I can’t get it to work with just 2 spreadsheets – and pulling only 1 column from the other spreadsheet. I have these fields on one spreadsheet. Worksheet Tab 1 Worksheet Tab 2...


View more questions Search