index match

**FDibbins** · 10-21-2012, 06:05 PM

i am trying to follow your logic in your file.

in your example, you are trying to find the value from AG26 and Y46?

some minor observations...
sheet1 must have taken you for ever to set up like that, it's really impressive

looking at sheet1 X45, you could simplify that by making (another? lol) table and referencing AG26 to there. and if you dont want to do that, you could just remove the "" from around the numbers "2", "3" etc, that way you can also simplify the formula in AJ44 to =IF(X45>6,X45,6)

**DANWEST87** · 10-21-2012, 06:58 PM

Thanks again. Yes I have been thinking about tables a lot recently. Since trying to work out the formula for my current problem I have now discovered using index match with tables. I would of typed the whole thing out in a formula if you were allowed more than 64 arguments in a formula (like the last sheet cell A1 that was my experiment lol) Originally certificate was just a form I printed off and filled in by hand. But i decided to play and make my working day a little bit easier. So long story short, the whole sheet could probably be a lot more simpler if I had know all this in the first place. But oh well Im just going to run with it now. I just really cant understand what I need to add to this formula to make it work.

Thank You