Steviefiege
Board Regular
- Joined
- Aug 29, 2018
- Messages
- 66
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>
</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
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:
Alex Kiwomya | INJ | ||||||||
Alfie Beestin | CM | 46.67 | Carrilero | 45.50 | Taken | ||||
Alfie May | CF | 51.67 | Yes | ||||||
Ali Suljic | WB (Right) | 41.50 | BPD | 40.29 | Taken | ||||
Andrew Williams | INJ | ||||||||
Andy Boyle | BPD | 64.71 | Yes | ||||||
Andy Butler | BPD | 62.06 | Yes | ||||||
Ben Whiteman | Carrilero | 57.50 | Yes | ||||||
Branden Horton | BPD | 30.00 | |||||||
Cameron Barnett | CF | 33.81 | |||||||
Carlton Cole | CF | 57.14 | Yes | ||||||
Cedric Evina | LOANED OUT | ||||||||
Craig Alcock | WB (Right) | 58.00 | BPD | 56.47 | Taken | ||||
Danny Amos | WB (Left) | 43.50 | |||||||
Danny Andrew | INJ | ||||||||
Issam Ben Khemis | Carrilero | 50.50 | CM | 42.92 | NOT WORKING | ||||
James Coppinger | CM | 57.92 | Yes | ||||||
Joe Wright | BPD | 53.24 | WB (Right) | 49.50 | NOT WORKING | ||||
John Marquis | CF | 57.38 | Yes | | |||||
Jordan Houghton | INJ | | |||||||
Liam Mandeville | LOANED OUT | | |||||||
Luke McCullough | INJ | | |||||||
Mathieu Baudry | INJ | | |||||||
Matty Blair | WB (Right) | 58.50 | Yes | | |||||
Mitchell Lund | LOANED OUT | | |||||||
Myron Gibbons | CF | 35.24 | | ||||||
Niall Mason | WB (Right) | 56.50 | WB (Right) | 56.50 | NOT WORKING | ||||
Reece Fielding | BPD | 48.82 | | ||||||
Rieves Boocock | CF | 34.29 | |||||||
Rodney Kongolo | INJ | ||||||||
Shane Blaney | WB (Right) | 48.00 | BPD | 47.35 | Taken | ||||
Tom Anderson | BPD | 50.88 | |||||||
Tommy Rowe | WB (Left) | 59.50 | Yes | ||||||
Tyler Walker | WB (Right) | 38.00 | |||||||
Will Longbottom | CF | 46.67 |
<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>
</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