"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.