This is somewhat of a followup to my post "does item match any in column B",
and was answered by bj and Gary's STudent. But, I have some followup to this
I was hoping to learn.


Thanks to the last couple of answers people helped me with, I'm able to do
pretty much what I want with matching these scenarios, but now I was
wondering what the possibility would be in regards to, in using a helper
column, the following scenario.


If I have data in column A and Column B -- and for an example to not be so
vague, let's say that each field in Column A is a customer name, and column B
is their corresponding customer number.

Now, I've brought a handful of names over and I put them in column C. Using
Column D as a helper column and this formula:


=IF(COUNTIF(A:A,C3)0, "Duplicate", "")

I can find out how many of the records are already in column A.

But, moving on, I'd like to see about pulling the customer ID from column B
if there is a match, and putting that in column D. I just don't know what to
put in the function to get this to happen... if I had the time, I'd go
searching through the Excel help and other sites, and that would be more fun
ultimately, but alas, I'm hoping you or someone can help.


Again, I'd be grateful for whatever help folks can provide.
Thank you.
matt