Number and date
 

If I have on my spread sheet the following :-


(D-1) 20
(D-2) 50
(D-3) 10

(E-1) 5/1/2015
(E-2) 6/4/2015
(E-3) 7/5/2014





The "D" cells are just a number and the "E" cells are the date when that
number occurred

In A-1 I have =MAX(D1:D100) to find the maximum number for the 100 D cells,
but what I want is in the B-1 cell the date where the maximum was found and
I do not know the formula.

The answer should be, if I have that formula :-

A1 cell would be 50
B1 cell would be 6/4/2015

Can anyone help?


---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

Number and date
 

Hi,

Am Mon, 11 May 2015 07:03:09 +1000 schrieb RamRodOz:

(D-1) 20
(D-2) 50
(D-3) 10

(E-1) 5/1/2015
(E-2) 6/4/2015
(E-3) 7/5/2014

try:
=VLOOKUP(A1,D1:E100,2,0)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Number and date
 

"Claus Busch" wrote in message ...

Hi,

Am Mon, 11 May 2015 07:03:09 +1000 schrieb RamRodOz:

(D-1) 20
(D-2) 50
(D-3) 10

(E-1) 5/1/2015
(E-2) 6/4/2015
(E-3) 7/5/2014

try:
=VLOOKUP(A1,D1:E100,2,0)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


Many thanks

Yes it works



---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com