PDA

View Full Version : Vlookup loop needed.


rsdjimbie
Nov 17, 2009, 02:52 AM
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. :(

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