i have data in my excel in below manner
L M N O P
-------------------------------------------------------
IO OVERALL PHYSICAL_READ READ SQL1
IO OVERALL PHYSICAL_WRITE WRITE SQL2
IO OVERALL PHYSICAL_READ AVG_READ SQL3
IO OVERALL PHYSICAL_WRITE AVG_WRITE SQL4
IO TABLESPACE_TOP PHYSICAL_READ READ SQL5
IO TABLESPACE_TOP PHYSICAL_READ AVG_READ SQL6
IO TABLESPACE_TOP PHYSICAL_WRITE WRITE SQL7
IO TABLESPACE_TOP PHYSICAL_WRITE AVG_WRITE SQL8
WAIT TOP_WAIT EVENT SQL9
WAIT EVENT SQL10
the E cell shouldcheck the data in A,B,C,D and compare against the above value and give the result of Q.
I tried then index and match function but i could compare it again two columns only.
Example VALUE of column B,C,D,
IO PHYSICAL_WRITE WRITE
The formula in E that i tried is
=INDEX($P$1:$P$9,MATCH(1,($B1=$L1:$L9)*($D$1=$O$1:$O$9),0))
but the above can compare only again 2 column ,when i try 3 columns it give me error
Bookmarks