Urgent Query: Excel Tables Issue

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
I am new to Excel and I have this issue, Have 3 columns with example values:

i.e I have 3 columns with definite set of values: like column 1 can have P1 P2 P3 P4 as values.
Column 2 can have Open,Reopened,Closed,InProgress as values.
Column 3 can have values like Resolved,Unresolved,Verified,Fixed..

I wanna make a table look like this:

Column 1: P1,P2,P3,P4
Column 2: Open/InProg/Reopen
Column 3: Closed
Column 4: Resolved
Column 5: Verified

i.e basically generate table 2 from table 1 by comparison like which P1s are still open...which P1 are unresolved etc.. ...thanks...


I am automating it through a macro...Can anyone help me with the formula to develop this..??

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi Shanks
Use vlookup function and if it matches with the "verfied" for column 5, then show it as "verfied" otherwise "" (use if also)
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month