Excel - can I return a date from 2 values in different columns? [Closed]

Report
Posts
2
Registration date
Monday May 19, 2014
Status
Member
Last seen
May 20, 2014
-
Posts
2
Registration date
Monday May 19, 2014
Status
Member
Last seen
May 20, 2014
-
Hi everyone, I have a spreadsheet which uses weeks (1,2,3 & 4) and days (M,T,W,T,F,S,S or 1,2,3,4,5,6,7 doesnt matter which).

Can I use a look up to return a date i.e. week 1 and day 1 = 02/06/2014

I seem to remember using a table but Im not brilliant with excel so if it can be done can you please keep it simple for me!! Thanks so much.

2 replies

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi Junerey,

You could make your sheet look like this:


Now you can use VLOOKUP to get your date as shown in B8:

Translated formula would look like: =VLOOKUP("Week 1",A1:H5,6)


Or in my opinion a better/easier way of retrieving date as shown in range D8:E11:

Translated formula would look like: =VLOOKUP("Week " &E8,A1:H5,1+E9)


Hopefully you appreciate my attempt at making it simple for you ;).

Best regards,
Trowa
Posts
2
Registration date
Monday May 19, 2014
Status
Member
Last seen
May 20, 2014

Thanks so much for your reply, I'll give this a go now. Really appreciate your clarity :)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!