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 •

#1
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

=IF(A1<>"",VLOOKUP(A1,SheetName!A1:B10,2,FALSE),"")

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

MIKE

http://www.skeptic.com/


Report •

#2
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