Sorry,you want info on different sheet, try this one;
=INDEX(Sheet1!A17:A22,MATCH("winner",(Sheet1!B17:B 22),0))
This is an array formula which must be entered by pressing CTRL+Shift+Enter
not just Enter. If you do it correctly Excel will put curly brackets
around the formula {=INDEX(Sheet1!A17:A22,MATCH("winner",(Sheet1!B17: B22),0))}.
HTH
John
"John" wrote in message
...
Hi
Try this =INDEX(A17:A22,MATCH("winner",B17:B22,0))
Column A are the names, column B Winner/Looser
Adjust range to your needs.
HTH
John
"Harold" wrote in message
...
I have an excel worksheet where one column is a list of names and the next
column either has the word "winner" or "loser". There is only one "winner",
so how do I get the "winner" to display in the first cell of the next sheet?
--
HL