VLOOKUP formula only partly working

[Steviefiege]

Hi,

This is my vlookup formula: =IF(M5="","",(IF(VLOOKUP(M5,$I$5:$K$39,3,FALSE)="YES","Taken",""))) but its only partly working. Below is my table:

<colgroup><col style="mso-width-source:userset;mso-width-alt:7314;width:150pt" width="200"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:365;width:8pt" width="10"> <col style="mso-width-source:userset;mso-width-alt:3803;width:78pt" width="104"> <col style="mso-width-source:userset;mso-width-alt:2157; width:44pt" width="59" span="2"> <col style="mso-width-source:userset;mso-width-alt:365;width:8pt" width="10"> <col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:2194;width:45pt" width="60"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> </colgroup><tbody>
[TD="class: xl66, width: 200"]Alex Kiwomya[/TD]
[TD="class: xl67, width: 90"]INJ[/TD]
[TD="class: xl64, width: 10"] [/TD]
[TD="class: xl67, width: 104"] [/TD]
[TD="class: xl68, width: 59"] [/TD]
[TD="class: xl68, width: 59"] [/TD]
[TD="class: xl65, width: 10"][/TD]
[TD="class: xl67, width: 73"] [/TD]
[TD="class: xl70, width: 60"] [/TD]
[TD="class: xl68, width: 59"] [/TD]

[TD="class: xl66, width: 200"]Alfie Beestin[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CM[/TD]
[TD="class: xl68"]46.67[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"]Carrilero[/TD]
[TD="class: xl70"]45.50[/TD]
[TD="class: xl68"]Taken[/TD]

[TD="class: xl66, width: 200"]Alfie May[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CF[/TD]
[TD="class: xl68"]51.67[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Ali Suljic[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl68"]41.50[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl70"]40.29[/TD]
[TD="class: xl68"]Taken[/TD]

[TD="class: xl66, width: 200"]Andrew Williams[/TD]
[TD="class: xl67"]INJ[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Andy Boyle[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl68"]64.71[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Andy Butler[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl68"]62.06[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Ben Whiteman[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]Carrilero[/TD]
[TD="class: xl68"]57.50[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Branden Horton[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl68"]30.00[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Cameron Barnett[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CF[/TD]
[TD="class: xl68"]33.81[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Carlton Cole[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CF[/TD]
[TD="class: xl68"]57.14[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Cedric Evina[/TD]
[TD="class: xl67"]LOANED OUT[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Craig Alcock[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl68"]58.00[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl70"]56.47[/TD]
[TD="class: xl68"]Taken[/TD]

[TD="class: xl66, width: 200"]Danny Amos[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Left)[/TD]
[TD="class: xl68"]43.50[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Danny Andrew[/TD]
[TD="class: xl67"]INJ[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Issam Ben Khemis[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]Carrilero[/TD]
[TD="class: xl68"]50.50[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"]CM[/TD]
[TD="class: xl70"]42.92[/TD]
[TD="class: xl68"] NOT WORKING
[/TD]

[TD="class: xl66, width: 200"]James Coppinger[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CM[/TD]
[TD="class: xl68"]57.92[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Joe Wright[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl68"]53.24[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl70"]49.50[/TD]
[TD="class: xl68"] NOT WORKING
[/TD]

[TD="class: xl66, width: 200"]John Marquis[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CF[/TD]
[TD="class: xl68"]57.38[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Jordan Houghton[/TD]
[TD="class: xl67"]INJ[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Liam Mandeville[/TD]
[TD="class: xl67"]LOANED OUT[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Luke McCullough[/TD]
[TD="class: xl67"]INJ[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Mathieu Baudry[/TD]
[TD="class: xl67"]INJ[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Matty Blair[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl68"]58.50[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Mitchell Lund[/TD]
[TD="class: xl67"]LOANED OUT[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Myron Gibbons[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CF[/TD]
[TD="class: xl68"]35.24[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Niall Mason[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl68"]56.50[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl70"]56.50[/TD]
[TD="class: xl68"] NOT WORKING
[/TD]

[TD="class: xl66, width: 200"]Reece Fielding[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl68"]48.82[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"]
[/TD]

[TD="class: xl66, width: 200"]Rieves Boocock[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CF[/TD]
[TD="class: xl68"]34.29[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Rodney Kongolo[/TD]
[TD="class: xl67"]INJ[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Shane Blaney[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl68"]48.00[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl70"]47.35[/TD]
[TD="class: xl68"]Taken[/TD]

[TD="class: xl66, width: 200"]Tom Anderson[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]BPD[/TD]
[TD="class: xl68"]50.88[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Tommy Rowe[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Left)[/TD]
[TD="class: xl68"]59.50[/TD]
[TD="class: xl68"]Yes[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl69"]Tyler Walker[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]WB (Right)[/TD]
[TD="class: xl68"]38.00[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl66, width: 200"]Will Longbottom[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl67"]CF[/TD]
[TD="class: xl68"]46.67[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl68"] [/TD]

</tbody>

The ones i've put in bold down the side are the ones that arent working. Its baffling me why. They should say "Taken" but there just blank. Can anyone help please?

Rgs
Steve

 

[Peter_SSs]

Actually Scott, that formula did & didnt work. It said taken which i wanted it to say, but i also want it to say "yes" if on the first column no one is in that position

Small sample data and expected results to demonstrate that situation?

Is it this?

=IF(M5="","",(IF(COUNTIFS(I$5:I$39,M5,K$5:K$39,"Yes"),"Taken","Yes")))

 

[Steviefiege]

I've tweaked it a little bit now, in my formula: =IF(M5="","",(IF(VLOOKUP(M5,$I$5:$K$39,3,FALSE)="YES","Taken","")))
Where i've made it bold, instead of it saying yes, how do i make it so its any word? What do i put in instead of yes

 

[Steviefiege]

Thats its Peter, thats worked a treat, thank you.

 

[Peter_SSs]

Thats its Peter, thats worked a treat, thank you.

You're welcome.

I've tweaked it a little bit now, in my formula: =IF(M5="","",(IF(VLOOKUP(M5,$I$5:$K$39,3,FALSE)="YES","Taken","")))
Where i've made it bold, instead of it saying yes, how do i make it so its any word? What do i put in instead of yes

If you are still looking for a way to count anything in place of the bold YES, try

=IF(M5="","",(IF(COUNTIFS(I$5:I$39,M5,K$5:K$39,"<>"),"Taken","Yes")))

 

[Steviefiege]

Got another question Peter,

In my table below:
In the last column where it says POS TAKEN in bold, how do i put 2 VLOOKUP formula's in? Similar to the last one you did, but instead of just checking the first POS TAKEN like you just did, it needs to check the 2nd one as well.

[TABLE="width: 925"]
<colgroup><col><col><col><col><col span="2"><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]PLAYER[/TD]
[TD]SQUAD INFO[/TD]
[TD] [/TD]
[TD]BEST POSITION[/TD]
[TD]RATING[/TD]
[TD] POS
TAKEN
[/TD]
[TD] [/TD]
[TD]2ND BEST POSITION[/TD]
[TD]RATING[/TD]
[TD]POS TAKEN[/TD]
[TD] [/TD]
[TD]3RD BEST POSITION[/TD]
[TD]RATING[/TD]
[TD]POS TAKEN
[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Alex Kiwomya[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Alfie Beestin[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]BWM[/TD]
[TD]45.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Alfie May[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CF[/TD]
[TD]51.67[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ali Suljic[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Right)[/TD]
[TD]41.50[/TD]
[TD] [/TD]
[TD][/TD]
[TD]BPD[/TD]
[TD]40.29[/TD]
[TD]Taken[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Andrew Williams[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Andy Boyle[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BPD[/TD]
[TD]64.71[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Andy Butler[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BPD[/TD]
[TD]62.06[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ben Whiteman[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Carrilero[/TD]
[TD]57.50[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]BWM[/TD]
[TD]54.09[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Branden Horton[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BPD[/TD]
[TD]30.00[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Cameron Barnett[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CF[/TD]
[TD]33.81[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carlton Cole[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CF[/TD]
[TD]57.14[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Cedric Evina[/TD]
[TD]LOANED OUT[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Craig Alcock[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Right)[/TD]
[TD]58.00[/TD]
[TD] [/TD]
[TD][/TD]
[TD]BPD[/TD]
[TD]56.47[/TD]
[TD]Taken[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Danny Amos[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Left)[/TD]
[TD]43.50[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Danny Andrew[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Issam Ben Khemis[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Carrilero[/TD]
[TD]50.50[/TD]
[TD] [/TD]
[TD][/TD]
[TD]CM[/TD]
[TD]42.92[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]BWM[/TD]
[TD]40.45[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]James Coppinger[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]BWM[/TD]
[TD]53.64[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Joe Wright[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BPD[/TD]
[TD]53.24[/TD]
[TD] [/TD]
[TD][/TD]
[TD]WB (Right)[/TD]
[TD]49.50[/TD]
[TD]Taken[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John Marquis[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CF[/TD]
[TD]57.38[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jordan Houghton[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]CM[/TD]
[TD]54.17[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Liam Mandeville[/TD]
[TD]LOANED OUT[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Luke McCullough[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]WB (Right)[/TD]
[TD]56.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Mathieu Baudry[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Matty Blair[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Right)[/TD]
[TD]58.50[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Mitchell Lund[/TD]
[TD]LOANED OUT[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Myron Gibbons[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CF[/TD]
[TD]35.24[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Niall Mason[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Right)[/TD]
[TD]56.50[/TD]
[TD] [/TD]
[TD][/TD]
[TD]WB (Right)[/TD]
[TD]56.50[/TD]
[TD]Taken[/TD]
[TD][/TD]
[TD]BWM[/TD]
[TD]54.09[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Reece Fielding[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BPD[/TD]
[TD]48.82[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Rieves Boocock[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CF[/TD]
[TD]34.29[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Rodney Kongolo[/TD]
[TD]INJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]CM[/TD]
[TD]54.17[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Shane Blaney[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Right)[/TD]
[TD]48.00[/TD]
[TD] [/TD]
[TD][/TD]
[TD]BPD[/TD]
[TD]47.35[/TD]
[TD]Taken[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Tom Anderson[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BPD[/TD]
[TD]50.88[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Tommy Rowe[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Left)[/TD]
[TD]59.50[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]CM[/TD]
[TD]56.67[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Tyler Walker[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]WB (Right)[/TD]
[TD]38.00[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Will Longbottom[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CF[/TD]
[TD]46.67[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

What are the expected results and why?
Remember that I am not familiar with what your data is about and just what you are trying to do.

 

[Steviefiege]

For example: Under BEST POSITION, there is no one playing BWM, under 2ND BEST POSITION there is no one playing BWM, under 3RD BEST POSITION there is one player who so far hasn't got a yes next to his name at all, NIALL MASON, in POS TAKEN at the end i want it to say "yes" in there & then in all the other ones to say "taken"

 

[Peter_SSs]

The lookups appear to have grown from 1 to 2 to now 3. Is that all there will be?

In any case, I still don't fully understand and I have no idea what row you are talking about in post 17, so why not show all the expected results for all the rows and provide any further clarification you can.
It would also be helpful to know what columns and what rows we are looking at (like you can see in post 5). My signature block below has some help about that.