I did the clean thing and it didn't help...yes the spelling and case are
exactly the same because I copied it from one to another so I know it is
identical...I am at a loss.

"clr" wrote:

You're on the right track.......assuming your VLOOKUP formula is put in
Worksheet B cell H2 and copied down it should work.....also assuming that
Worksheet A is named Sheet1. Things that can confound this situation is
that the Names have to be exactly the same, in spelling and with regard to
leading or trailing spaces.........copy and paste A2 from Worksheet B to A2
Worksheet A (if it's named Sheet1) and it should work.....indicating that
there is a difference in spelling or invisible spaces, etc.

Post back if you still have problems

Vaya con Dios,
Chuck, CABGx3



"klmiura" wrote in message
...
I have two separate worksheets

Worksheet A

COLUMNA COLUMNB
Insurance Company Name Maketer NAME

Aetna John Smith
BCBC Mary Doolittle
Abbington Mike Doe

Worksheet B

COLUMNA COLUMNH
Insurance Company Name Marketer Name
Aetna
BCBC
Abbington

I need the Marketer Name to show up in Column H of Worksheet B based upon
the insurance company matching in both worksheets. I have done the
following
formula however it does not work...I am thinking I have to do an
array...can
someone help me? =VLOOKUP(A2,Sheet1!A1:B68,2,FALSE)




.