Dear experts,
Appreciate if you could help me to devise a formula to lookup a table with multiple matches using three columns three columns:
Example
<A> <B> <C> <D>
<1> date time name value
<2> 01-12-02 00:00 Apple (Excel formula?)
<3> 01-12-02 01:00 Apple (Excel formula?)
<4> 01-12-02 02:00 Apple (Excel formula?)
<5> 01-12-02 03:00 Apple (Excel formula?)
<6> 01-12-02 00:00 Pear (Excel formula?)
<7> 01-12-02 01:00 Pear (Excel formula?)
...
...
The Lookup Table
----------------
<W> <X> <Y> <Z>
<1> date time name value
<2> 01-12-02 01:00 Pear 834754
<3> 01-12-02 00:00 Apple 38475
<4> 01-12-02 01:00 Apple 456459
<5> 01-12-02 00:00 Pear 345656
<6> 01-12-02 02:00 Apple 454445
<7> 01-12-02 03:00 Apple 456453
thanks in advance.
Appreciate if you could help me to devise a formula to lookup a table with multiple matches using three columns three columns:
Example
<A> <B> <C> <D>
<1> date time name value
<2> 01-12-02 00:00 Apple (Excel formula?)
<3> 01-12-02 01:00 Apple (Excel formula?)
<4> 01-12-02 02:00 Apple (Excel formula?)
<5> 01-12-02 03:00 Apple (Excel formula?)
<6> 01-12-02 00:00 Pear (Excel formula?)
<7> 01-12-02 01:00 Pear (Excel formula?)
...
...
The Lookup Table
----------------
<W> <X> <Y> <Z>
<1> date time name value
<2> 01-12-02 01:00 Pear 834754
<3> 01-12-02 00:00 Apple 38475
<4> 01-12-02 01:00 Apple 456459
<5> 01-12-02 00:00 Pear 345656
<6> 01-12-02 02:00 Apple 454445
<7> 01-12-02 03:00 Apple 456453
thanks in advance.