Hiya, what i am trying to do (in english) is this.

Enter a formula in E4 that says if L4 is populated then lookup L4 in 'RidersList'!F4:F315 and return the corresponding value from 'riderslist'!A4:A315

They are all random values and not in any order or anything.

Help???

Thanks!