Confused on what to use ????? vlookup with different criteria
Thankyou for your help
"Bob Phillips" wrote:
Kate,
Do you mean something like
=INDEX(E1:E20,MATCH(1,(A1:A20="aa")+(A1:A20="cb"), 0))
or maybe even
=INDEX(E1:E20,MATCH(1,(A1:A20="aa")*(B1:B20="gyn") *(C1:C20="c")*(D1:D20="att
"),0))
which is an array formula (both are), it should be committed with
Ctrl-Shift-Enter, not just Enter.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"kate" wrote in message
...
ok Please can you help me here goes
I have a table showing this data
1 2 3 4 5 6 7
aa gyn c att 23 22 21
aa gyn s att 11 26 31
aa gyn c h 14 00 36
aa vas c att 11 15 28
cb obs c att 10 08 43
cb obs s h 11 12 14
this is an example of the data which goes on for about 500 rows I want to
put a formula into a report which will pull out on certain criteria for
example I would like my report to give me the number in colomn 5 for the
person initials in colomn 1 showing he is a gyn showing he is a c and att
my report does not work because i have more than one set of criteria for
"aa" in the first colomn. i used a vlookup but I am unsure how to do this
with all the filtering needed
please help me
thankyou so much
kate
|