column query

Giganews Newsgroups
Subject: column query
Posted by:  Mat (buffaloesi…
Date: Thu, 6 May 2004


I am trying to return a value in a column of a table based on a value in a
cell in the same row but different column.

For example, column A is a list of names, column B is a list of scores. In a
separate area i want to display the highest score with the name of the
person that achieved it. I've tried using MAX to display the highest score
but cannot think of a way to show who this value relates to in column A.

Does this make sense?

Many thanks for any help