If - Then

[TLK]

Hi Everyone

I am trying to have a spreadsheet that I can use for a charity race night tonight.!!

I have two worksheets. worksheet #1 called 'results'. worksheet #2 called 'sheet 2'.

I need a formula to look at the punters horse choice on 'sheet 2' and look to see if it finished in place 1st, 2nd or 3rd on 'results' sheet. In a cell on 'sheet 2' I want the formula to display the place, i.e. 1st, 2nd, 3rd or U/P....

If the result is 1st, 2nd or 3rd, then I need a formula in the next cell to calculate the winnings based on whether the bet was placed to win or to be placed.

Am I being too adventurous or is this possible?

Many thanks in advance for any help anybody can offer!

TLK

[TLK]

I tried this, but the result is '#N/A' when in fact the horse I am referring to finishes 1st.

=IF(COUNTA(C6:D6)=2,INDEX(RESULTS!B2:J5,MATCH(D6,RESULTS!C3:C5,0),MATCH(D6,RESULTS!A2:A5,0)),"")


Sheet 2 C6:D6 = horse number:horse name

Results C3:C5 = horse name in finishing position

Results A2:A5 = finishing position, i.e. A3=1st, A4=2nd, A5=3rd


Any help would be appreciated

[martindwilson]

tried putting that on a sheet but couldnt seee quite what you want. could you attach what youve done so far and indicate what you want where?

[Richard Buttrey]

Does the attached example workbook give you any ideas?

Regards