Formual Error

**mithoo** · 03-19-2009, 06:54 AM

I am attaching the sheet where i have applied the formula and unfortunately i am not able to locate the error in it..
kindly assist...
thanks

**squiggler47** · 03-19-2009, 07:03 AM

it might get you more help if you tell us what you are trying to achieve and what your columns are!!!!

**mithoo** · 03-19-2009, 07:21 AM

Actualy, i want to pick up values based on B8 (all the repeated values in the list on the side of it)
e.g value G is repeated two times so in the table all G related values should be filled.
I hope this clarifies.

**martindwilson** · 03-19-2009, 07:50 AM

lable the columns i cant tell what ones are really wanted,
but i suspect your column ref is wrong, you are refering to col j1 (column 10)
which is just wrong.