#REF! on Auto sort table

**ojstimpy** · 03-15-2011, 04:53 PM

For some strange reason I cant auto sort the right hand table with the bottom table although I think the values are correct. Basically the green portion of the right hand table should auto sort with the green portion at the bottom. The same follows with the blue, but it keeps showing #REF! I have attached the sheet.MVCC Season3test2.xls

**MarvinP** · 03-15-2011, 05:31 PM

Didn't I just answer this a few minutes ago?

Get rid of merged cells and try not to use Column() in the formula.
Try to put in a number for Column() and see what happens.

**ojstimpy** · 03-15-2011, 05:51 PM

Sorry about that, I did both options, and same issue.

**MarvinP** · 03-15-2011, 07:32 PM

OK so on further examination.

Looking at BK16 you have a formula. You also have one in BM16. You have cells BK16 to BM16 merged into a single cell. Which is supposed to be used in the merged bigger cell? I hate Merged Cells.

See the attached where I've unmerged and corrected the vlookup formula for the first cell.