Ignore "-1" in formula

Hello

I have this formula

=INDEX([TUE.xlsx]Who_Did_What!$D1:$D10000,MATCH(1,($F7 = [TUE.xlsx]Who_Did_What!$C$1:$C$10000)*([TUE.xlsx]Who_Did_What!$D$1:$D$10000<>""),0))

Column D in "TUE.XLSX" has many '-1's in it so therefore the cell with this formula in it returns -1

The cell with the formula is trying to return an employee ID of which im doing a VLOOKUP to match a name with. There is nobody with this ID '-1'.

What can i put in this formula to ignore minus numbers or just specifically -1.

It has to be in this formula as the users are not advanced users and will not know anything about formulas.

I attached an example - cant attach the original for DP reasons

Thanks

I've attached literally a mirror image of what i am working with, see attached.

So i want to see ID '130' in cell I7, sheet 2. But the formula stops at -1 or sometimes 0.

Like i said before, nobody has -1 or 0 as their ID so i wish the formula to ignore this.

Raw data in sheet 1.

The raw data will be in another worksheet but as mentioned before to me this doesn't matter.

I will try to explain further.

You helped me with the same sheet a few days ago.
The product that is F7 "288 GH SMALL ITEM", sheet 2, is the product i am trying to find the corresponding employee ID in row D, sheet 1.

The difference between employee number 874 and employee number 130 is that 874 does not have an employee name attached to it, as you can see in E1 (sheet 1). I do not know why this is because this has been exported from another program external to excel, so sorry can't explain that one. I'm guessing it is a way of identifying a type of action performed.

Just like the other problem you helped me solve, the formula i'm guessing, is picking up the first corresponding value in column D, which was -1. And again, -1 has no employee attached to it so therefore i wish to skip pass -1 (and also 0) and go to the next corresponding value in column D, which is "130", name "Richard Smith".

Hope this makes sense,

If not please ask away. The sheet is literally a mirror image, i've just changed the names of products and people. Obvious reasons.

Thank you

Thanks for this Glenn

Can i ask what was changed because immediately i cant tell (and so i can learn too)

p.s. it works on the real sheet too thank you again!!!