Looking up a cell that is left of the current column

**ynot2010** · 02-06-2011, 12:49 AM

Hello All.

I have an excel problem where i want to look-up a date in one column and then wish to find the date in the previous column of the same row.

I then need to do the same, though this time for a column two (2) columns to the left of the target column and so on.

I cannot seem to get the 'left look-up' and/or 'index/match/offset' functions to work either.

I have attached a draft copy of the excel sheet.

Any urgent advice would be very much appreciated.

Thank -you.

Ynot2010.

**MarvinP** · 02-06-2011, 01:36 AM

Hi ynot2010,
See if the formulas in the yellow cells are what you want. See the attached.

**protonLeah** · 02-06-2011, 01:37 AM

J27:

Please Login or Register  to view this content.

k27:

Please Login or Register  to view this content.

**martindwilson** · 02-06-2011, 11:24 AM

k7 =INDEX($E$7:$BX$7,MATCH($L$27,$E$7:$BX$7,0)-1)
j7 =INDEX($E$7:$BX$7,MATCH($L$27,$E$7:$BX$7,0)-2)
i7=INDEX($E$7:$BX$7,MATCH($L$27,$E$7:$BX$7,0)-3)

but since you have consecutive weeks why not just
k7=L27-7
j7=K27-7
I7 =J27-7