IF OR query (or VLOOKUP?) inside an Index-Match

Hey

 

First time poster so hope i’m doing this right! I’m new to excel formulas and apst 2 days have learnt a lot! I’ve got the forumla below that returns nth match if the target cell range is not blank:

=INDEX(‘Weekly Overview’!$A$4:$A$33,SMALL(IF(‘Weekly Overview’!$H$4:$H$33<>””,ROW(‘Weekly Overview’!$H$4:$H$33)-ROW(‘Weekly Overview’!$H$4)+1,ROW(‘Weekly Overview’!$H$33)+1),1)),””)

However instead of the <>””, i’m trying to make it pick up certain matches. I’ve tried:

=IFERROR(INDEX(‘Weekly Overview’!$A$4:$A$33,SMALL(IF(OR((‘Weekly Overview’!$H$4:$H$33=”1″,’Weekly Overview’!$H$4:$H$33=”2″), ROW(‘Weekly Overview’!$H$4:$H$33)-ROW(‘Weekly Overview’!$H$4)+1,ROW(‘Weekly Overview’!$H$33)+1),1)),””)

But i know the syntax is wrong somehow, but can’t figure it out!

Insted of just “1” or “2” values to look for, i’ve got an entire range, so wonder if it would be possible to use a vlook in the middle of that?

There’s likely an easier way to achieve things, but my knowledge is limited!

Using Windows 7.

My thanks in advance.

 

By: Simon Woolley

Leave a Reply

Your email address will not be published. Required fields are marked *