Pull info from separate worksheet based on given criteria
My apologies for the confusion. I don't think I explained my worksheets very
well. I need a formula for worksheet 2 that will actually pull the project
title from Worksheet 1 if certain criteria is met. So if none of the
projects meet the criteria, then worksheet 2 would actually be empty except
for the formulas.
Thanks again!
"Dave Peterson" wrote:
Your data doesn't need to be sorted for =vlookup() to work.
Since you want an exact match (right?) based on project #, then you should make
sure you use the 4th parm (0 or false):
=vlookup(a1,sheet2!a:e,2,false)
That 4th parm = 0 or false means you want an exact match.
Chas wrote:
Unfortunately the projects won't be nicely organized the way my example was.
I believe V-lookup needs the info to be sorted by alphabetically and our
projects will never be sorted that way.
"dlw" wrote:
vlookup formula using the !sheetname referencing will work
"Chas" wrote:
I have 2 worksheets. The first has a list of all projects and the second
needs to pull projects based on certain criteria.
Worksheet #1
Project % $'s Date
Proj #1 85% $$$ 10/15/08
Proj #2 17% $$$ 11/07/08
Proj #3 62% $$$ 09/29/08
Proj #4 99% $$$ 08/15/08
Proj #5 47% $$$ 12/15/08
Proj #6 89% $$$ 10/15/08
Proj #7 70% $$$ 10/15/08
From this worksheet i want to pull only those projects with a % higher than
a given critieria.
I would prefer to do this with a formula as result needs to be live.
Any help that can be given is greatly appreciated.
Thanks
--
Dave Peterson
|