Dynamic Cell info based on another cell text

[yunier2002]

Hello All,

I'm trying to implement a workflow sheet in where I'll have a section of a sheet pull information from another worksheet based on a row cell status text.

Attached is the worksheet I'm doing. What I'm looking for is to pull the rows from the workflow sheet that corresponds to the right status.

For example all the rows that has status as "Graphics" be pulled out and displayed in the Graphics worksheet. And if the status of the row changes that it moves it to the right area and deletes it from the old area status. See worksheet attached for better understanding what I mean.

I created a data range and used the vlookup function to pull out the info from the workflow sheet but it just gets one row and if I put the same vlookup function in all cells it just pulls the same info.

Anyone have a better idea to implement this?

Thanks in advance everyone

[NBVC]

Is this what you are looking for? See attached... I completed only the Graphics Section... you will need to update for other sections.

Note the formula in A3 is an array formula...once entered you need to confirm it with CTRL+SHIFT+ENTER not just ENTER.. you will see { } brackets appear around it.... then you can copy it down and across the table.

[yunier2002]

Awesome!!! That's exactly what I was looking for, thanks. Now to do the other ones what do I have to edit so that it only gets the specific status (ex. Production, Output, etc) I can't figure it out. Thanks again!

[NBVC]

You need to edit where the $A$1 where I coloured in Red (2 places) in the formula below.

The A1 is the cell containing the word "Graphics"

If you want you can just replace $A$1 with the string "Graphics" or whatever string to search for...

Please Login or Register  to view this content.