okay posted question realized may vague , many people may not understand i'm posting again clarify things. have 2 worksheets, namely; july ' 15 rel , release dev status.
both of these worksheets have column heading of "erequest id" in column a. have copy two columns, "dev / ut plan end date" , "dev / ut actual end date" release dev status on july ' 15 rel when "erequest id" of both worksheets matches.
for eg: if there record "erequest id" of 41316 in both worksheets, need copy "dev / ut plan end date" , "dev / ut actual end date" data record 41316 in release dev status on july '15 rel
i asked use vlookup function tried out , don't think it'll work number of rows in both data uneven. pardon me dont have codes guys start off with, have no idea how start @ all...
also if helps, data in format "22/04/2015" example. also, apart column "erequest id", other columns in both worksheets different. may have same heading in different orders. thank guys in advance helping out!
just in previous post the answer vlookup formula in both columns:
dev ut end date:
=vlookup(a2;'release dev status'!a$1:z$1000;column($i$1);false) dev ut actual date:
=vlookup(a2;'release dev status'!a$1:z$1000;column(j$1);false) change range 'release dev status'!a$1:z$1000 appropriately.
Comments
Post a Comment