Hi,

I wonder if it is possible to use a Vlookup in conjunction with some
logical expressions to not just match a specified value, but also
return a value in the specified column if it is equal to or greater
than a value?

I have a main worksheet that looks like this:

A B C
Date Price Shares Owned
06/08/2005 59.11
05/08/2005 59.11
04/08/2005 58.9
…..


I then have another worksheet that details dates when purchase
transactions took place:

A B C D E
Ref Purchase Date No Shares Price Per Share Total Shares
144 25/04/2005 50 53.3 50
145 27/05/2005 25 54.94 75
146 29/06/2005 25 56.37 100

In my main worksheet, for each ‘Shares Owned’ Cell I would like to be
able to perform a lookup against the purchase date and return the value
in column E if the date is equal to or greater than the purchase date.

Any help would be appreciated!


--
dazman
------------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...o&userid=25903
View this thread: http://www.excelforum.com/showthread...hreadid=393674