Is the formula pointing to the correct columns in the other sheets?

Are the values you are trying to pull numeric or text? My formula assumed numeric only as per your sample data.

Are you getting an error? If so what is it?