|
Posted to microsoft.public.excel.misc
|
|
|
extract of data with 3 different conditions?
Got it! Thank you.
"Max" wrote:
Indicatively, use an IF(ISNA error trap on the MATCH bit, viz.:
=IF(ISNA(MATCH(..)),"Nil",INDEX(..))
In D2, copied down:
=IF(ISNA(MATCH(1,INDEX((Sheet1!A$2:A$6=A2)*(Sheet1 !B$2:B$6=B2)*(Sheet1!C$2:C$6=C2),),0)),"Nil",INDEX (Sheet1!D$2:D$6,MATCH(1,INDEX((Sheet1!A$2:A$6=A2)* (Sheet1!B$2:B$6=B2)*(Sheet1!C$2:C$6=C2),),0)))
voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"P2000" wrote:
Thanks it work perfectly, but can we return a "Nil" message in the host
column if the index is unable to satisify any one of the name, dept, group.
Currently I got the error #N/A if any of the group is not met.
|