Sorry not great at excel (used to be but its been a while since I have played with it)
i have fours sheets.
sheet1 = has
Submission Date E-mail First Name Last Name Age Driver 1 Driver 2 Driver 3 Team 1 Team 2
sheet 2 has
what i need to do on sheet 4 is if sheet1 driver1 = 25 (for example) for it to lookup sheet 2 cost and return driver cell
hope this makes sense