I have a table, the range is: sheet!2$E$4:sheet2!$I$7
E F G H I
4 39447 $30 $7.50 $2.50 3.00%
5 39802 $42 $6 $1.75 1.75%
6 40111 $38 $3.75 $.90 .59%
7 40651 $52 $4.25 $3.25 2.75%
Back on Sheet1 I am trying to use the latest date in col. E and display the amount in col. F. In this case 40651 & $52.
My formula looks like this.
=VLookup(Sheet2!$E$4, Sheet2!$E$4:Sheet2!$I$7,2) always returns 39447.
As I read the writeup for VLookup it should seek the greatest value in E and
return the related amount.
Where have I gone astray?
column E4 thru E7 = serial dates (e.g. 30/Jun/2007 = 39447)
E F G H I
4 39447 $30 $7.50 $2.50 3.00%
5 39802 $42 $6 $1.75 1.75%
6 40111 $38 $3.75 $.90 .59%
7 40651 $52 $4.25 $3.25 2.75%
Back on Sheet1 I am trying to use the latest date in col. E and display the amount in col. F. In this case 40651 & $52.
My formula looks like this.
=VLookup(Sheet2!$E$4, Sheet2!$E$4:Sheet2!$I$7,2) always returns 39447.
As I read the writeup for VLookup it should seek the greatest value in E and
return the related amount.
Where have I gone astray?
column E4 thru E7 = serial dates (e.g. 30/Jun/2007 = 39447)