Lookup

Giganews Newsgroups
Subject: Lookup
Posted by:  Khalil Handal (khhand…@stthom.edu)
Date: Sun, 28 Jan 2007

Hi,
In sheet2 cell F14 I have the following formula:
    =LOOKUP($C$1,SHEET1$A$14:$A$58,SHEET1I14:I58)

Instead of finding the correspondant value in colomn I, Is it possible to
display the AVERAGE of the 2 cells I+J ?
What changes should I make to the previous formula?

Khalil

Replies