Need a Formula to return a list of data that matches 3 criteria in seperate columns

Hi JDUBS,

See how this works:Index.match.criteria.help.xlsx

Some notes:
1) The rows/columns I highlighted are just for reference to the requirements
2) column B has some spelling issues, which will affect this solution, (cleint instead of client for example), there may be be others in other columns as well
3) you will have to adjust the formatting on output report sheet to properly show dates, right now it shows the serial number of the date

Hope this helps

You are welcome !

sure

Formula:

Please Login or Register  to view this content.

The match is matching up the column titles, in the first column(C) the C$9 looks in row 9 column C for the column title, then finds that in the column header row of your Input Log page, it will return the column number it finds it in
this number is actually used in the Index part of the equation to tell which column stores the information being looked for, if you move 1 column to the right, it will look like this:
MATCH(D$9,'Input Log'!$A$4:$N$4,0)

C1 isn't being used anywhere??

Hope this helps

Okay, I see where you found it, the C in Row(C1) is basically ingnored, its the 1 we are interested in, SMALL(array,k),
the 1 says to find the smallest value in the array, as the formula moves down, it will increment to c2,c3,c4,c5 etc..the numbers telling excel which "smallest" to return, this will keep the data going to the next item that matches the criteria

also, if you look across the row , the c1 will change to d1,e1 etc, as I said, the letter part is ignored, Row will return the row number (1)