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!
=IF(L4<>"", INDEX('riderslist'!$A$4:$A$315, MATCH(L4, 'riderslist'!$F$4:$F$315,0)))
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes! Thank you
T
For completeness I think you need a double quotes just inside the final closed bracket:
=IF(L4<>"",INDEX('riderslist'!$A$4:$A$315, MATCH(L4,'riderslist'!$F$4:$F$315,0)),"")
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks