Comments
-
So I took a closer look at the email fields and found some inconsistency in regards to capitalization. I added some text formatting to force all lower case before the data join and all data seems to be populating. I wouldn't have thought that 1 mismatch on case sensitivity would stop the rest of the data from populating.…
-
I hope it isn't too anonymized to get the idea here. When I join the data using a unique identifier and pull out these columns, I have their name columns, the TRUE is if my criteria met and then I want to pull the other information you see in the last two columns from the master sheet. The data just stops. Spot checking…
-
You'll have to forgive me, I'm sure I'm not using the best of terms to explain things. So my "so called master list" is just my holy grail of information. The report is only on a small fraction of the master and I really only want the 3000 rows from the report. I need to pull data from the larger master list to fill in…
