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
Bookmarks