Excel calculating same dates as different values???

**hijinxx** · 05-15-2012, 02:56 AM

Hi There

I have a workbook with 2 sheets, I have the same dates on sheet one and two and I am trying to use VLOOKUP to match them. However it is not working as excel is calculating the same date differently on both sheets. IE on sheet one when I express 2.9.02 18:58 as a number I get 37501,79059 while the same date on sheet two is calculated as 37501,79028 ??

any Ideas as why this is?

Thanks

**canapone** · 05-15-2012, 03:13 AM

Hi,

a possible solution could be

=INDEX(Sheet2!$B$1:$B$1000,MATCH(INT(A2),INDEX(INT(Sheet2!$A$1:$A$1000),),0))

In the example Sheet2 column A houses dates.

Regards

**hijinxx** · 05-15-2012, 03:49 AM

Hi

Thanks for the replay. What I am actually trying to do is match dates from sheet one and two and then return the number two columns to the left of that number. I have attached an example sheet.

Thanks

**canapone** · 05-15-2012, 04:52 AM

Hi,

please doublecheck if what you get from the formula is unexpected.

=INDEX(Sheet2!$E$1:$E$51,MATCH(TEXT(D1,"GG/MM/AAAA HH.MM"),INDEX(TEXT(Sheet2!$D$1:$D$51,"GG/MM/AAAA HH.MM"),),0))

Regards

**hijinxx** · 05-15-2012, 06:10 AM

Thank you thats it.

Excel calculating same dates as different values???

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Excel calculating same dates as different values???

Re: Excel calculating same dates as different values???

Re: Excel calculating same dates as different values???

Re: Excel calculating same dates as different values???

Re: Excel calculating same dates as different values???

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions