Hi, I have a tab that I am trying to pull all student grades to based on the data dropped into another tab. Tab 1: Tab 2 (also contains data for grades 6 & 7): How do I make the column on Tab 1 pull grades for each subject based on the subject's name in Tab 2? Everything I have tried gives me an error.

You need to use wildcharacter while using the formula. Kindly share the link of the file for further assistance or DM

Forum Discussion

Copper Contributor

Jan 15, 2024

Hi,

I have a tab that I am trying to pull all student grades to based on the data dropped into another tab.

Tab 1:

Tab 2 (also contains data for grades 6 & 7):

How do I make the column on Tab 1 pull grades for each subject based on the subject's name in Tab 2? Everything I have tried gives me an error.

Excelonlineadvisor
Iron Contributor
Jan 15, 2024
You need to use wildcharacter while using the formula. Kindly share the link of the file for further assistance or DM