On the attached sheet on the overview sheet in the 'missing mark' column I need it to lookup 'Abyna' in sheet 'reading' column E and insert false, if the child is not on the column.
Column E on 'Reading' sheet has Abyna, but not Alexia.
Any help with this would be very much appreciated :-)
Hi,
One way
Formula:
Please Login or Register to view this content.
However I question your assertion that Alexia doesn't exist. She does in E72.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Is this only based on column E? Are there any other columns that need to be used?
Alexia is in E72, by the way.
THis, copied down, will tell you how many times a name appears - there are no missing names...
=COUNTIF(Table1[[Baseline]:[End of Year 6 Target]],Overview!D2)
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
Thanks Richard that works perfectly.
p.s. I deleted Alexia from my list but didnt save before uploading - sorry :-0
BIG THANKS FOR THE HELP :-)
There are two other columns 'writing' and 'maths'. I just tried to simplify the spreadsheet to make it easier to explain.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks