Comparing Data

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have four columns.

id_fm, customer_fm, id_gp, and customer_gp

Columns A, B, C and D respectively

Column A is empty
Column B has customer names
Column C has customer IDs
Column D has the same customer names as column B, but
with more

I want to compare Column B to D and when a match is found
I want to enter the corresponding value from column C
into column A. Column C and D have the customer ID and
Customer matched correctly. Column B has customers but
there are no corresponding customer IDs in column A. I
want the function to enter the correct customer ID into
column A. Thanks!

Frank
 
Didn't I answer this a few days ago?

In A1 and fill down:

=INDEX(C:C,MATCH(B1,D:D,0))

HTH
Jason
Atlanta, GA
 
Back
Top