Solved Project status update help

November 24, 2015 at 03:18:41
Specs: Windows 7
I'm hoping someone can assist me....I pulling data into excel from 2 sources onto one sheet. I have lots of info coming in & I now want to create a simple report from all this data. The data has various project numbers & each project has multiple line items. I would like to simply have 3 things on a different sheet, a search box where I can input any project number then the search should yield the project status & the furthest date of all my line items for that project. The project status & furthest date are available in my data I previously mentioned

See More: Project status update help

Report •

November 24, 2015 at 08:00:11
✔ Best Answer
The simplest way would be with a LOOKUP() of some sort.

Cell A1 is your search box


Depending on where your data resides on the other sheets,
just do two lookups, one for Project Status, and one for Date.


Report •

November 24, 2015 at 10:55:36
Worked well Mike, thanks a lot. It was actually the simplest way to get exactly what I needed!

Report •

Related Solutions

Ask Question