G
Guest
Hi,
I would like to see any excel formula (vlookup/ index & match) can help to
return the desired value:
See below -
apple shop A 2/15/2006 ??? < ---- (to be returned as 0.5)
apple shop B 3/27/2006 ??? < ---- (to be returned as 0.6)
Lookup table:
A B C D E
apple shop A 1/1/2006 2/28/2006 0.5
apple shop A 3/1/2006 5/30/2006 0.7
apple shop B 1/1/2006 1/2/2006 1
apple shop B 1/3/2006 3/28/2006 0.6
thanks
I would like to see any excel formula (vlookup/ index & match) can help to
return the desired value:
See below -
apple shop A 2/15/2006 ??? < ---- (to be returned as 0.5)
apple shop B 3/27/2006 ??? < ---- (to be returned as 0.6)
Lookup table:
A B C D E
apple shop A 1/1/2006 2/28/2006 0.5
apple shop A 3/1/2006 5/30/2006 0.7
apple shop B 1/1/2006 1/2/2006 1
apple shop B 1/3/2006 3/28/2006 0.6
thanks