VLookUp Formula Help

Hello Excel Guru's

I have a standard VLookUp formula

Please Login or Register  to view this content.

However I need to modify it and or a new formula the will do the following:

First look at cell R18

• If R18 is < 10 return the value of 0 and end
• If R18 > = 10 then continue with the normal VLookUp and return the value in column 2 from the array table

Thanks in advance - Let me know if you need anymore info

Try:

Formula:

Please Login or Register  to view this content.

Thank you .. may need another slight tweak

With the above formula it is reading the table array so long as the value is 10 + and returning the lowest value.

With 10 Players and Finishing 10th .. Bonus points should be 0 because the array table should only reward the extra points if placed 9th and above.

See the attached workbook

How about L18

=(I18>9)*(I18<>J18)*VLOOKUP(J18,$E$7:$F$15,2)