Code Explanation Help Please

Hi Guys,

I am at my Witts end, I am an Access VBA programmer by trade but have been asked to look at some excel stuff for a friend.

Can anyone, even if just a little bit, Explain what is going in in this code? I know its a very ambiguous question but I am ready to chuck the PC out the window.

The Code is

=IF(ISERROR(INDEX(Log!$F$1:$S$1100,SMALL(IF(Log!$F$1:$F$1100=Categories!$B$2,ROW(Log!$F$1:$S$1100)),ROW(1:1)),3)),"",INDEX(Log!$F$1:$S$1100,SMALL(IF(Log!$F$1:$F$1100=Categories!$B$2,ROW(Log!$F$1:$S$1100)),ROW(1:1)),11))

What it does is take information from worksheet - Log and populate it into a new sheet where this formula is present. The criteria is that the categorie will match a specific field in the sheet.

I am not familiar with the terms INDEX, SMALL and ROW. I have done a little research but its all far more basic than this and i cant make head nor tail of it. Especially ROW(1:1)),3) and ROW(1:1)),11)

Any Help would be amazing

Thanks in advance

Sean

Hello gerbansprawl What you want to know about above formula

basically Index formula Returns the value of an element in a table or an array, selected by the row and column number
syntax for index formula is : INDEX(array,row_num,column_num)

Here in below formula
INDEX(Log!$F$1:$S$1100,SMALL(IF(Log!$F$1:$F$1100=Categories!$B$2,ROW(Log!$F$1:$S$1100)),ROW(1:1)),3))
Log!$F$1:$S$1100= array or range
SMALL(IF(Log!$F$1:$F$1100=Categories!$B$2,ROW(Log!$F$1:$S$1100)),ROW(1:1)) = row number
3=Columnnumber