I am new here, and I have searched the forums to check whether this question has been dealt with but I can’t seem to find the exact answer.
I have a long list of customer IDs (ALLINFO) and other details (of which I want the email addresses). Unfortunately, the associated email addresses are mixed in with this long list of IDs.
All data is in column A of a calc sheet I have. I have managed to pull all the IDs to a column of a new sheet (customerinfo, col A), and I would like to now paste the email address associated to each of these IDs in to a new column (col B).
The list of info is such that when there is an email address, I know for sure that it belongs to the customer ID just above it. I assume I have to do a MATCH INDEX mix, but I don’t understand how I can ask it to pull out the cell content containing the email address which is just below it.
So in my new sheet I would like to have something like this:
Customer ID_A - If [Customer ID_A is in list on sheet ALLINFO, give me the row just below it, else nothing]
Customer ID_B - If [Customer ID_B is in list on sheet ALLINFO, give me the row just below it, else nothing]
and so on.
Do I have to do a SEARCH, MATCH, INDEX, LOOKUP ?? Am very confused as to what’s the best way forward.
Thanks for any help you can give.