= index

  1. ourfear

    =INDEX =Headache...

    Hi Peeps, Im working on what i thought would have been an easy spreadsheet. Basically Im looking up data from a table, then im using the index function to sort the data. This all works fine.e.g: =INDEX($A$1:$C$7,SMALL(IF($A$1:$B$7=$E$1,ROW($A$1:$B$7)),ROW(1:2)),3) Which looks up the text in...

Some videos you may like

This Week's Hot Topics