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. :(
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. :(