Copy your formula down column H to see if any of the other names come
through.........what return ae you getting from your formula...... are you
getting, #N/A or something else? Rename Worksheet A to the Sheet1 name same
as is in your formula.....even if it already looks like it matches, it may
have a leading or trailing space.

Vaya con Dios,
Chuck, CABGx3





"klmiura" wrote in message
...
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)




.