Hi all,
Need some help with an issue I'm having.
I have attached the worksheet below.
The issue that I'm having is that when two different people are selected from the dropdown lists in cells C10 and C12, the "Batting" table (starting in D132) shows every other person as being "IN" (from cells E10:E30). Added to this, when numbers are added to cells K10:AD11, the "Batting" table shows all players as getting these scores. How can this be fixed?
Thanks
Hi, welcome to the forum
Looks like you left off the last argument in VLOOKUP...
=IFERROR(VLOOKUP($D133,$C$10:$BN$31,3,0),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try
E133=IFERROR(VLOOKUP($D133,$C$10:$BN$31,3,FALSE),"")
Formula:
Please Login or Register to view this content.
Hope this will help you
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you heaps! Looks like that simple error caused me a long headache! Thanks for the fix. Much appreciated.
Thank you heaps! Looks like that simple error caused me a long headache! Thanks for the fix. Much appreciated.Originally Posted by FDibbins
Hi, welcome to the forum
Looks like you left off the last argument in VLOOKUP...
=IFERROR(VLOOKUP($D133,$C$10:$BN$31,3,0),"")
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks