Complex Formula writing
Posted by Bob on October 19, 2001 6:12 AM
How do you write a complex formula utilizing data off a matrix. One cell has to equal 1 of 20 cells in the data base rows..and then another cell has to equal 1 of 10 cells in data base columns.
Posted by Travis on October 19, 2001 6:19 AM
Not sure if I understand what your asking, but sounds like =vlookup might work???
Posted by loren on October 19, 2001 8:04 AM
You can use the INDEX and MATCH functions together to find a value in a list based on a row or column label, or both labels. INDEX returns a reference to a cell at the intersection of a particular row and column within a range, and MATCH finds the relative position of a cell within a range, based on a value you want to look up. In combination, these functions return a value based on either a row or column label. The Lookup Wizard uses INDEX and MATCH in the formulas it creates.
