Multi worksheet if cell not equal check next row

[JRPark]

Here is what I am trying to do. I have a multi worksheet workbook. The first tab is the master and I want the other tabs to reference the master. So on tab 2, I want cell C4 to search for "Down Low" in cell B11 on the master tab, if it is "Down Low" then enter value from cell F11 into cell C4 on tab 2. If B11 on the master doesn't equal "Down Low" then move to cell B12, If B12 is 'Down Low' then enter the value of F12 into cell C4 on tab 2. I want this to repeat through out tab 2 so I only get the data from row B that has "Down Low" in it. Hope that makes sense.

 

[My Aswer Is This]

I'm confused.
We want to search what sheets for what value.
It seems as if you might want to search all sheets but then you say Tab 2
And what is the name of this master sheet.

So search for value found in??
See this is confusing to me:
Your quote:
So on tab 2, I want cell C4 to search for "Down Low" in cell B11 on the master tab, if it is "Down Low" then enter value from cell F11 into cell C4 on tab 2. If B11 on the

 

[JRPark]

maybe this will make it more clear, sorry for the confusion.

Master tab

Tab 2 below

 

[JRPark]

Hi again,
I figured out the formula with some help, below is the formula if this helps anyone else out. Remember, when you enter the formula you cant just hit enter when you are done, you have to hold the Shift and Ctrl keys down when you hit enter so it makes it an array and adds the { } at front and end.

=IFERROR(INDEX(Master!B$3:B$6,SMALL(IF(Master!$A$3:$A$6="High",ROW(Master!$B$3:$B$6)-ROW(INDEX(Master!$B$3:$B$6,1,1))+1),ROW()-2)),"")