VLookup returns value in first row

Joined
Jul 18, 2006
Messages
5
Reaction score
0
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top