VLOOKUP

[Darren]

I have a sheet with four columns! a,b,c,d

Column A has nothing in it and is labeled id_fm

Column B has 2870 rows of customers and is labeled
customer_fm

Column C has 4132 rows of customer ids and is labeled
id_gp

Column D has 4132 rows of customers and is labeled
customer_gp

I want to compare column B to all entries in cloumn D and
when it finds a match, enter the value from cloumn C into
column A. The valsu that should be entered into column A
is the value in the same row as the value that is matched
in cloumn D.

I have been trying an IF and VLOOKUP, but I can not seem
to figure it out. Example

A B C D
A1 Landscaping AABROC A & A BROCHU, INC
A & A BROCHU, INC LANDA1 A1 Landscaping

The function should yield

A
LANDA1
AABROC

Any help would be greatly appreciated.

Darren
MCP

 

[Jason Morin]

Put in A1 and copy down:

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

HTH
Jason
Atlanta, GA

 

[Guest]

or just switch column C and D (D to the left of C) and use
C as your range.

 

[Guest]

Thanks for the reply. I can not seem to get this to work
however. The error in the cell is #NAME?. Thanks!