My thanks goes out to anyone that can help me with this...possibly even
off list if need be.

Here are a few questions regarding Vlookup


- Does Vlookup work only on column a? How do you get around this if
you need to match different columns and/or different data?
- Can you do a Vlookup "or" meaning I have if it matches "active" or
"large" the information should pull.
- How do you keep all of the data together? Meaning if I have 50
projects and 20 are active I get 30 rows of errros. How do you start
with the first match and then continue in consective rows all of the
next rows. Example: first row might be active, next active project
may be at row 20. How do you make this show up on row 2 on the
summary page?
- Many more q's I am sure as I work my way through this.


Thanks in advance!!!


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=534271

"streetboarder"
wrote in message
news:streetboarder.26iwum_1145470204.3633@excelfor um-nospam.com...

- Does Vlookup work only on column a? How do you get around this if
you need to match different columns and/or different data?

=INDEX(C2:C200,MATCH(1,(A2:A200="val1")*(B2:B200=" val2"),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

as an example


- Can you do a Vlookup "or" meaning I have if it matches "active" or
"large" the information should pull.

=INDEX(C2:C20,MATCH(1,(A2:A20="val1")+(A2:A20="h") ,0))

gain an array

- How do you keep all of the data together? Meaning if I have 50
projects and 20 are active I get 30 rows of errros. How do you start
with the first match and then continue in consective rows all of the
next rows. Example: first row might be active, next active project
may be at row 20. How do you make this show up on row 2 on the
summary page?

Not sure I get this one.

Does Vlookup work only on column a?

It works on the left hand column of the range that you select as the
second arguement in the function. This does not have to be column A

How do you get around this if you need to match different columns
and/or different data?

Use a different lookup range.

Can you do a Vlookup "or" meaning I have if it matches "active" or
"large" the information should pull.

More tricky - the best I've managed to come up with is

=IF(ISNA(VLOOKUP("Large",A1:B3,2,0)) =
TRUE,"",VLOOKUP("Large",A1:B3,2,0)) &
IF(ISNA(VLOOKUP("Active",A1:B3,2,0)) =
TRUE,"",VLOOKUP("Active",A1:B3,2,0))

which pulls back the data in column 2 or range A1 to B3

How do you keep all of the data together? Meaning if I have 50 projects
and 20 are active I get 30 rows of errros. How do you start with the
first match and then continue in consective rows all of the next rows.
Example: first row might be active, next active project may be at row
20. How do you make this show up on row 2 on the summary page?

Sorry - don't understand this bit.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=534271

Ok. Still not getting it so hang in there with me. Let's try the easier
one first.

I am trying to match the following text in cells (RawData!AD14:AD100)
text = "Not Started" If there is a match, I need to pull the "project
managers name" located on the same sheet in cells (RawData!D14:D100)

This information needs to go to (Overview!A5). I need to be able to
copy this formula down so it pulls all of the projects manager name by
"not started" and leaves blanks below if nothing matches.

The next cell to the right (Overview!B5) needs to pull the information
for priority number for the same projects "not started"
(RawData!AD14:AD100) pull the priority number from (RawData!A14:A100).

Thanks for your help


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=534271

sorry if this is a double post I couldn't tell if the last one was
posted.
----

Ok. Still not getting it so hang in there with me. Let's try the easier
one first.

I am trying to match the following text in cells (RawData!AD14:AD100)
text = "Not Started" If there is a match, I need to pull the "project
managers name" located on the same sheet in cells (RawData!D14:D100)

This information needs to go to (Overview!A5:A100). I need to be able
to copy this formula down so it pulls all of the projects manager name
by "not started" and leaves blanks below if nothing matches.

The next cell to the right (Overview!B5:B100) needs to pull the
information for priority number for the same projects "not started"
(RawData!AD14:AD100) pull the priority number from (RawData!A14:A100).

Thanks for your help


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=534271