Vlookup but also consider equal to or greater than a valu

[dazman]

Hi,

Posted this in the wrong forum so repost here.

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!

[Rob Hargreaves]

If I get what you are saying then you could do the vlookup to display in one
cell then use IF in another cell to display true or false or 1 or 0 in an
adjacent cell then you can sort them to get the desired result

Hope that helps

Rob
"dazman" <dazman.1tej2c_1123430720.7895@excelforum-nospam.com> wrote in
message news:dazman.1tej2c_1123430720.7895@excelforum-nospam.com...
>
> Hi,
>
> Posted this in the wrong forum so repost here.
>
> 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=393676
>
>

[dazman]

Thanks - I added that logic to what the lookup wizard generated and it did the trick!