Thread: [Solved] how to look up for multiple criteria
View Single Post
 
Old 06-15-2015, 06:38 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,367
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
In that case, you could change:
$E$1
to:
$E$1:$I$1
Code:
=IF(ISERROR(INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$E$1:$I$1,ROW($A$1:$A$14)),ROW(1:1)),2)),"",INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$E$1:$I$1,ROW($A$1:$A$14)),ROW(1:1)),2))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote