Error? VLOOKUP returns 0 instead of proper value.

**Hatchiman** · 10-17-2010, 07:05 AM

I am having a very weird problem with the table in the attached file.

The table contains 5 columns titled INFO 1-5.

When I code a VLOOKUP function, some of the columns return the proper value. However, some of the columns return a 0

.

No matter what I type in the column, or even if I paste this table in a new document, I cannot get the proper value to show.

Does anyone know why? and how to solve this?!

**peterjuhnke** · 10-17-2010, 07:13 AM

hello h
what are you trying to look up, were did you want the formula
regards
peter

**zbor** · 10-17-2010, 07:15 AM

Because you have merged cells (which I hate above all

)

Try 8 instead of 4

=VLOOKUP(value, table, 8, FALSE)

**Marcol** · 10-17-2010, 07:18 AM

Why have you merged the cells in every row? You are creating a massive problem for yourself.

=VLOOKUP(value,table,11,0)

Will give you the answer I think your formula is asking for.

What are you trying to get?

[EDIT]
Try this workbook
based on this

=VLOOKUP(value,table,COLUMN(),0)

Seect a value from the dropdown in A28

**Hatchiman** · 10-18-2010, 02:42 AM

I'm smacking my head! Merged layers?! How did I not notice such a trivial thing.
I simply unmerged them and everything works great now.

Thank you gentlemen (or ladies).