Forum Discussion
Lous_Performance_Centr
Apr 20, 2020Copper Contributor
Lookup table command use.
I am out of my depth. I have a POS system with thousands of names and email addresses and several thousand have asked to unsubscribe from our newsletter list. I could go into our POS system an...
Lous_Performance_Centr
Apr 21, 2020Copper Contributor
Thank you for your help Riny. I did some reading before I contacted the group and was lead to believe the INDEX command may work a little more easily. This is the command I’ve written =INDEX($L$2:$L$10348, MATCH($C2, $K$2:$K$10348, 0) ) but It doesn’t work. However I can’t see what is wrong
Column L has "email" as a name and has no email addresses in it. Column C is the concatenated first and last names of all our customers, column K is the concatenated first and last names of everyone that wants their email addresses removed. So I am trying to have the two columns compared and then blank data from column L written into the data from all our customers where names are found in each set column C and column K.
You are correct getting the information back into our POS is separate.
Can you help? I can’t understand what is wrong with what I’ve written.
Riny_van_Eekelen
Apr 21, 2020Platinum Contributor
Lous_Performance_Centr Revised my earlier file, believing it does exactly what you describe. Still a simple VLOOKUP, creating a listing (shaded green in the example) that you can then copy and paste as values on top of the old e-mail column.