Having trouble with VLOOKUP

[liameyres]

Hello I am working on a personal project to track points for FPL with my own twist (in case you were curious about the context)
My current setup is this:
excelhelp.PNG
My current function for the Bonus column under the 'Liam' row is as follows:

Please Login or Register  to view this content.

where column D is the Cap? column, column E is the unique? column, Column F is the Score column and J247:K248 is the separate Cap table, and M247:N248 is the separate Unique table.
As the picture hopefully shows, if both Cap? and Unique? columns are 'Yes' then the desired result is achieved, but the problem I'm having is that if either are 'No' then I get a #N/A error. If required, the Tom and Stan rows of the Bonus column functions are given respectively:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is my first post on these forums so apologies if I have presented anything in a trickier way accidentally, and thanks for any help in advance!

[TMS]

Welcome to the forum.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[liameyres]

Re: hopefully sample workbook can now be accessed

[Fluff13]

You are doing an approximate match, hence the error, try

Please Login or Register  to view this content.

[liameyres]

Thank you, this fixed my issue

[Fluff13]

Glad to help & thanks for the feedback.