Urgent Query: Excel Tables Issue

Closed
Shanks - Jun 24, 2009 at 01:41 PM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Jun 27, 2009 at 08:37 AM
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

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 27, 2009 at 08:37 AM
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