Forum Discussion
Extract Data from three data tabs based on an If, Index, Match Formula
I'm unable to upload files on her only images and tries to include column headings to help make it more understandable.
It IS possible, however, to post files on OneDrive or GoogleDrive and post a link here granting access to such a file. That would be far more likely to help us help you than the images you've posted here.
And if you could, please supplement that actual file with a more clear explanation of what you want to accomplish. In words. Leave the formula to us. Describe in words what you're trying to retrieve and how to make the connection between the various tabs.
Thanks for your reply.
https://1drv.ms/x/s!AoD5K4waScfenzZAUw5k6Inwz06g?e=YrGaxk
Here is the link to the file. In the tab called SIMS data there are pupil subject choices. A number 1 under the corresponding subject heading means that they study that subject. In the tab called FFT DATA there are targets for the pupils. However the targets are for every student regardless of whether they study the subject. In the tabs FFT50, FFT20 and FFT5, I would like to take the values from the FFT Data sheet under headings relating to the subject, for example the first subject is Art and Design and the three values for this subject i would like to take the grades from are Art and Design_FFT50_G, Art and Design_FFT20_G and Art and Design_FFT5_G and have the grade copy over for the corresponding subject in sheets FFT50, FFT20 and FFT5 but only if the student studies that course. However i would only like to take the number value and not the +/- after the number. And then repeat this for all other subjects.
Does this make sense?